| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple text criteria sum if function
What do you want to do with this? Is is possibly a SUMPRODUCT formula?
Since I'm having some SUMPRODUCT difficulties today, I'll leave this to someone else. "datasorter" wrote: can anyone tell me whats wrong with this formula and how to fix it? =sumif(and('[Upsell Monthly Report.xls]COB'!$A:$A,'[Upsell Monthly Report.xls]COB'!$C:$C),(A8,B8),('[Upsell Monthly Report.xls]COB'!$I:$I) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif function with multiple criteria | Excel Worksheet Functions | |||
| Justify text across multiple columns | Excel Discussion (Misc queries) | |||
| creating a function with multiple criteria | Excel Worksheet Functions | |||
| Counting by multiple criteria | Excel Worksheet Functions | |||
| COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
Threaded Mode
