SUMIF with criteria being a specific cell
 

I want the criteria to be a designated cell, is that possible?

SUMIF with criteria being a specific cell
 

Say A1 thru B7 contain:

cat 1
cat 2
hat 3
hat 4
bat 5
cat 6
rat 7

in D1 put:
cat
and then
=SUMIF(A1:A7,D1,B1:B7)
correctly displays 9
--
Gary''s Student - gsnu200909


"CSB" wrote:

I want the criteria to be a designated cell, is that possible?

SUMIF with criteria being a specific cell
 

Yes.

It would be handy if you gave some details, but you could have
something like this:

=SUMIF(A:A,""&C1,B:B)

This will add up the values in column B where column A values are
greater than the item in C1.

Hope this helps.

Pete

On Dec 29, 4:33*pm, CSB wrote:
I want the criteria to be a designated cell, is that possible?