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



Reply With QuoteReply With Quote