SUMIF - pointing to another cell for criteria

M

Mon Wolff

Please could someone tell me if it is possible to have the criteria point to
another cell, so you can the criteria wihtout having to rewrite the formula.
I've tried:

=SUMIF(A1:A20,"=D5",B1:B20)

but this brings a value of zero.

Thank you.

Monica
 
M

Mike

=SUMIF(A1:A20,D5,B1:B20)

You don't need the = or the quotes when using a cell reference.
 
B

Bob Phillips

=SUMIF(A1:A20,"="&D5,B1:B20)

in other words, concatenate the operator and the cell value.

But actually, the = is not needed, it is assumed, so you could just use

=SUMIF(A1:A20,D5,B1:B20)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
K

Krishna

Hi Monica,

Everything seems to be okay in your formula except the cell reference "=D5",
Just refer the cell that you want to have criteria point and dont insert it
into quotes...the formula would look like the below

=SUMIF(A1:A20,D5,B1:B20)

Thanks
 
Top