| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple text criteria sum if function
Bingo <bg
Peo "RagDyeR" wrote in message ... It's *still* not clear (to me) exactly what criteria refers to what range. The way the OP formula was constructed, anything is (was) possible.<g -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Peo Sjoblom" wrote in message ... True but my formula was wrong since I didn't observe that the OP used the A, the C and the I range, so it would be a regular sumproduct not the OR version I cooked up so =SUMPRODUCT(--('[Upsell Monthly Report.xls]COB'!$A$19:$A$1075=A8),--('[Upsell Monthly Report.xls]COB'!$C$19:$C$1075=C8),'[Upsell Monthly Report.xls]COB'!$I$19:$I$1075) might work -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Ragdyer" wrote in message ... Your ranges are *not equal*! They *must all* be exactly the same size. A19:A944 C19:C891 I19:I1075 Pick whatever range best suits your data, and equalize them ... THEN ... try again! -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "datasorter" wrote in message ... I tried this and I got #N/A =SUMPRODUCT(--(('[Upsell Monthly Report.xls]COB'!$A$19:$A$944=A8)+('[Upsell Monthly Report.xls]COB'!$C$19:$C$891=C8)0),'[Upsell Monthly Report.xls]COB'!$I$19:$I$1075) |
| 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
