| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple criteria in 2 different columns for a sum in a 3rd co
Thank you,
I saw what I was missing it works now. "Eduardo" wrote: Hi, try =sumproduct(--(masterdata!$d$2:$d$100="Infrastructure"),--(masterdata!$l$2:$l$100="PO"),masterdata!$n$2:$n$1 00) "Cyn" wrote: Trying to write a formula to fit this all info is on a different sheet in the same workbook. Masterdata(sheet name)( Column for 1st critera) D2:D100,(Critera)"Infrastructure", (Column for 2nd critera), L2:L100 ,(Critera)"PO", Sum N2:N100 My idea is that looking on the master data sheet if in Column D "Infrastructure" is chosen and in column L "po" is chosen then it will add totals in column N. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| create new table from Multiple Criteria in multiple columns | Excel Worksheet Functions | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
