software

I can't get SUMIF to add the values in a range. I tried:
=SUMIF(B3:B7,quot;Checkquot;,C3:E7)
But it doesn't add all the values in the range C3:E7. It adds only some of
them.

I can make it work by listing each column range to be added separately, like
this:
=SUMIF(B3:B7,quot;Checkquot;,C3:C7) SUMIF(B3:B7,quot;Checkquot;,D3 7) SUMIF(B3:B7,quot;Checkquot;,E3:E7)

But it's a major pain to enter that whole thing each time.

Any idea why it won't add a range?

Try...

=SUM(IF(B3:B7=quot;Checkquot;,C3:E7))

....confirmed with CONTROL SHIFT ENTER, not just ENTER.

Hope this helps!

In article gt;,
Kathy gt; wrote:

gt; I can't get SUMIF to add the values in a range. I tried:
gt; =SUMIF(B3:B7,quot;Checkquot;,C3:E7)
gt; But it doesn't add all the values in the range C3:E7. It adds only some of
gt; them.
gt;
gt; I can make it work by listing each column range to be added separately, like
gt; this:
gt; =SUMIF(B3:B7,quot;Checkquot;,C3:C7) SUMIF(B3:B7,quot;Checkquot;,D3 7) SUMIF(B3:B7,quot;Checkquot;,E3:
gt; E7)
gt;
gt; But it's a major pain to enter that whole thing each time.
gt;
gt; Any idea why it won't add a range?