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




Reply With QuoteReply With Quote