| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way to do this, SUMIF() question
=SUMPRODUCT((ISNUMBER(FIND({"W","A","M"},C12:C24)) *(Y12:Y24)))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. =SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12 :Y24) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF question (I think) | Excel Worksheet Functions | |||
| SUMIF function question | Excel Worksheet Functions | |||
| this may be simple, sumif question | Excel Worksheet Functions | |||
| sumif Question | Excel Discussion (Misc queries) | |||
| SUMIF question | Excel Worksheet Functions | |||
Threaded Mode
