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.

for multiple criteria, you can use sumproduct

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

--
Regards,
Tom Ogilvy

"SavageMind" <[email protected]> wrote in message
news:[email protected]...
> 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.