Sumif

[Brian]

Is there a way to use SUMIF to add a range? I would like
to be able to search for "CAR" in row 1, and if it finds
it, add all of the values in the columns A2:K10. Here is
my formula.

=SUMIF(A1:K1,"CAR",A2:K10)


TIA

 

[Brian]

Is there a way to adjust this to add the whole range
instead of just the row? Or do I have to continue for
this formula for every row? I have about 100 rows, is
there a limit to how many SUMIF's I can use?


TIA

 

[J.E. McGimpsey]

You can add the whole range:

=SUM((A1:K1="car")*(A2:K101))

This formula must be array-entered (CTRL-SHIFT-ENTER or CMD-RETURN).