SUMIFS criteria ">" a cell

I have =SUMIFS(C:C,B:B,">E4") but the formula is not picking up E4 as a cell b/c its in talking marks.

This version also fails. =SUMIFS(C:C,B:B,">"E4) It must be something really easy I'm missing

How can I make it recognise this as a cell using the > symbol?

MQ

Try like this

=SUMIFS(C:C,B:B,">"&E4)

Thx AlKey, the light bulb has gone off..

You're welcome and thank you for the feedback

Since there is a single criteria SUMIF will do:

=SUMIF(B:B,">"&E4,C:C)

Tony, out of curiosity, is SUMIF() any more (or less) efficient than SUMIFS() in a situ like this?

Tested on 5k rows of data...

Calculation times were almost identical:

Data Range

	E	F	G	H	I	J
4		Test1	Test2	Test3	Test4	Test5
5
6	=SUMIF(B:B,">"&E4,C:C)	0.00163	0.00163	0.00164	0.00164	0.00163
7
8	=SUMIFS(C:C,B:B,">"&E4)	0.00164	0.00165	0.00164	0.00165	0.00164