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

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

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

"Mon Wolff" wrote:

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

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



"Mon Wolff" wrote in message
...
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

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




"Mon Wolff" wrote:

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