sumif???

[Guest]

If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc)
and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a
formula to sum all numbers in column B whose corresponding color in column A
is "orange"? For example, A1 and A3 are "orange", so the formula delivers
"11", the sum of B1 (3) and B2 (8).

Thanks.

 

[Ian]

The Excel help on SUMIF explains exactly what you need to do and shows an
example. In your case you need =SUMIF(A1:A100,"orange",B1:B100). You may
need to amend the row range. It doesn't matter what cell you put the formula
in, as long as it isn't in one of the ranges in the formula.

 

[Guest]

Gee, I feel stupid. I didn't understand the difference between "range" and
"sum range" before. Now I do. Many thanks, Ian.

 

[Ian]

Glad to help. Thanks for the feedback.

--
Ian
--

Gee, I feel stupid. I didn't understand the difference between "range"
and
"sum range" before. Now I do. Many thanks, Ian.

 

[Guest]

You can also use:
=sumproduct(--(a1:a10="yellow")*(B1:b10))
Thanks