Problem with SUMIF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following funcation in cell G694:
SUMIF(C3:C690,"=SR22",G:G) and the result is 382.6

In cell G695 I have:
SUMIF(C:C,"=SR22",G:G) and the result is 388.2

The cells C1 and C2 are joined with a column heading of "AIRCRAFT MAKE &
MODEL".

For the record, C694 and C695 are empty (lest you suspect the formula were
adding values from those rows) and the correct answer is 388.2.

What gives? Why does the function give me two different results in the
values in rows 1 & 2 should not affect the results?
 
Off the top of my head, I would say there is something after row 690. Try
summing the values for G3:G690 and see if you still get 382.6. If you do, I
would say there is something after 690 that you are not seeing or can't see.
I would also venture to say the problem is in column C since that is the
search criteria and the second example (includes entire column) produces the
correct value.
 
Thanks for taking the time to reply. But unfortunately I considered that as
well. There is nothing in column C after row 690. I verified this by
selecting the entire column AFTER 690 and doing a Clear All command.
 
Is it not that the ranges start from different points in case 1?
therefore you are summing the cells 2 above where the actual match is found.
either change the C3 to C1 or change the col ref to G3:690 and the first one
will work fine

cheers
Simon

a
 
Both of your suggestions solved the problem. Thanks.

Thing is... I don't really think it should work this way. But I guess that
doesn't really matter. Hopefully I'll remember this the next time I use this
function!
 
Back
Top