Sum Alternate Cells

This will do the calc for you...
=SUMIF($B$7:$Q$7,"Pallets",$B8:$Q8)

but 1st, remove the trailing space in "Pallets " in your headings
Then change "Pallets" in the formula to "Cartons

Hiii t_man000,
=SUMIF($B$7:$Q$7,"*Pallets*",$B8:$Q8)
=SUMIF($B$7:$Q$7,"*Cartons*",$B8:$Q8)

This will work for you without removing spaces..

Mangesh, I agree with you completely that your formulas will work without the need to remove those extra spaces

However, it would be considered that the data is "dirty" with those extra spaces, and unless you can remember that they are there, they will undoubtedly cause more problems down the road. It is always - ALWAYS - better to try and clean up your data, rather than work around sloppy data input