View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eileenfz eileenfz is offline
external usenet poster
 
Posts: 1
Default I need to write a PRODUCT formula that mimics a SUMIF

I need to write a PRODUCT array =PRODUCT(1+(the values in column t that have
a value in column d that match the value in D841)-1)

Is there a way to do a PRODUCT like a SUMIF?
ex: =SUMIF(D:D,D841,M:M)

It's to replace this formula:
=((1+T654/100)*(1+T671/100)*(1+T688/100)*(1+T705/100)*(1+T722/100)*(1+T739/100)*(1+T756/100)*(1+T773/100)*(1+T790/100)*(1+T807/100)*(1+T824/100)*(1+T841/100)-1)