SUMIF with multiple criteria for multiple columns to sum a single
 

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.

SUMIF with multiple criteria for multiple columns to sum a single
 

for multiple criteria, you can use sumproduct

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

--
Regards,
Tom Ogilvy

"SavageMind" wrote in message
...
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.