SUMIF - pointing to another cell for criteria

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

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