SUMIF with multiple criteria for multiple columns to sum a single

S

SavageMind

I have a large database. I want to use a SUMIF or similar command to search a
single column, then search again within those results under another criteria,
then either AVERAGE or SUM the another column based on those results.
The columns I'm searching (filtering) all have a repeated formula in them so
this needs to go in it's own cell(s) sepately and work.
 
T

Tom Ogilvy

for multiple criteria, you can use sumproduct

=sumproduct(--(A1:A10>3),--(A1:A10<12),B1:B10)
 

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

sumif wildcard for text and numbers 5
Sum data using sumif 3
Multiple Columns in Sum Range using SUMIFS 1
SUMIF with criteria "<>" & "=" 4
VLOOKUP or SUMIF for Multiple Criteria 2
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 3
SUMIFS, one criteria range, multiple criteria 2
Summing Criteria with Index - Match 4

Top