SUMIF - pointing to another cell for criteria

[Guest]

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

 

[Guest]

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

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

 

[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)

 

[Guest]

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