SUMIFS criteria ">" a cell

1. 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

2. Re: SUMIFS criteria ">" a cell

Try like this

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

3. Re: SUMIFS criteria ">" a cell

Thx AlKey, the light bulb has gone off..

4. Re: SUMIFS criteria ">" a cell

You're welcome and thank you for the feedback

5. Re: SUMIFS criteria ">" a cell

Since there is a single criteria SUMIF will do:

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

6. Re: SUMIFS criteria ">" a cell

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

7. Re: SUMIFS criteria ">" a cell

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1