sumif and multiple columns

U

umass

I am trying to get sumif to sum over multiple columns -- that is, the
criteria are in range A1:A3, and the sum range is over B1:D3, but I
can't get it to work. Is this possible to do?
 
J

JE McGimpsey

One way:

Assume your criterion was A1:A3 > 5:

=SUMPRODUCT((A1:A3>5)*(B1:D3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Multiple Columns in Sum Range using SUMIFS 1
Sum data using sumif 3
SUMIF with criteria "<>" & "=" 4
Looking to added up based on a character from cell range 1
sum multiple columns with SUMIF or SUMPRODUCT 3
Sumif using partial string 7
SUMIF evaluating blank DATE data 2

Top