| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Multiple columns using single criteria | Excel Worksheet Functions | |||
| SUMIF, One criteria multiple columns | Excel Discussion (Misc queries) | |||
| SUMIF - multiple criteria in different columns | Excel Worksheet Functions | |||
| SUMIF with multiple criteria, by columns | Excel Worksheet Functions | |||
| Sum Count of Single Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hybrid Mode
