You could just do this with SUMIF (which is less resource intensive
than Sumproduct):

=SUMIF($1:$1,"Sales",$2:$2)

Best regards

Richard



FJ wrote:
Hi, I have a huge spreadsheet with over 250 columns. There are over 40
columns with the heading "Sales" and I have to add the numbers under each of
the "Sales" headings together. Does anyone know the best way to do this?
Clicking on every cell is timeconsuming, but even trying that doesn't work
because apparently there is a limit to how much Excel will accept in a SUM
formulas of that nature. Is there a way to do this using SUMIF to specify
adding only the numbers under the "Sales" headings or any other way?

Thanks in advance for any help or suggestions.