SUMIF

[Jastacio]

why does the SUMIF function return incorrect values when
the range and the sum_range are not equal in rows? For
example"
=sumif(a1:a10,a14,b2:b10)

 

[Juan Sanchez]

Because the logic of the SUMIF is go Check a CELL in
RANGE1 to see if the value MATCHES with what i want, and
then if TRUE, concider its CORRESPONDING CELL in RANGE2
for the sum, if both ranges are not the same size, then
excel cannot figure out the CORRESPONDING CELL part.

Cheers
Juan

 

[Peter]

-----Original Message-----
why does the SUMIF function return incorrect values when
the range and the sum_range are not equal in rows? For
example"
=sumif(a1:a10,a14,b2:b10)
.

It looks like you are missing out a row of data to me (B1)
sumif(a1:a10,a14,b1:b10)worked for me.

Peter Atherton

 

[Harlan Grove]

why does the SUMIF function return incorrect values when
the range and the sum_range are not equal in rows? For
example"
=sumif(a1:a10,a14,b2:b10)

It doesn't. You're misusing SUMIF if you're giving it 1st and 3rd argument
ranges of different shape/size. If you misuse a formula, don't complain if it
doesn't give you what you want.

FWIW, your formula should produce the same results as

=SUMIF(A1:A9,A14,B2:B10)

What's your data, and what do you expect your result to be?