| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way to do this, SUMIF() question
=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12:Y24)
|
|
#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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easier way to do this, SUMIF() question
Hi!
Try this: =SUMIF(C12:C24,{"W","A","M"},Y12:Y24) Biff "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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easier way to do this, SUMIF() question
Ooops!
Disregard my reply! Biff "Biff" wrote in message ... Hi! Try this: =SUMIF(C12:C24,{"W","A","M"},Y12:Y24) Biff "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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easier way to do this, SUMIF() question
No!
=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24)) <vbg Bob "Biff" wrote in message ... Ooops! Disregard my reply! Biff "Biff" wrote in message ... Hi! Try this: =SUMIF(C12:C24,{"W","A","M"},Y12:Y24) Biff "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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easier way to do this, SUMIF() question
THanks
"Bob Phillips" wrote in message ... No! =SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24)) <vbg Bob "Biff" wrote in message ... Ooops! Disregard my reply! Biff "Biff" wrote in message ... Hi! Try this: =SUMIF(C12:C24,{"W","A","M"},Y12:Y24) Biff "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) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easier way to do this, SUMIF() question
You don't even need sumproduct, a simple sum will do the same:
=SUM(SUMIF(C12:C24,{"W","A","M"},Y12:Y24)) -- Regards, Dave "Bob Phillips" wrote: No! =SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24)) <vbg Bob "Biff" wrote in message ... Ooops! Disregard my reply! Biff "Biff" wrote in message ... Hi! Try this: =SUMIF(C12:C24,{"W","A","M"},Y12:Y24) Biff "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) |
| Reply |
| 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 | |||
Linear Mode
