SUMIF with criteria being a specific cell

[CSB]

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

 

[Gary''s Student]

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

 

[Pete_UK]

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