SUMIF with multiple criteria for multiple columns to sum a single

G

Guest

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 2
Vlookup or SumIF to sum multiple cells matching the same criteria 0
SUMIF criteria 1
SUMIF with criteria "<>" & "=" 4
SUMIF with multiple criteria 4
Sumif with multiple conditions 3
Multiple Coumns Criteria 3
MULTIPLE CRITERIA RETURNING SUM OF RESULTS 5

Top