Thread: Is there an easier way to do this, SUMIF() question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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)







Reply With QuoteReply With Quote