I need to write a PRODUCT formula that mimics a SUMIF
If you are using Excel 2007, you can use whole columns:
=PRODUCT((1+IF(D:D=$D$841,T:T,0)/100))-1
Again, this must be entered using CTRL+Shift+Enter. I'm not sure if whole
columns will work with PRODUCT in earlier versions of Excel.
Hutch
"Tom Hutchins" wrote:
Try
=PRODUCT((1+IF(D100:D841=$D$841,T100:T841,0)/100))-1
Adjust the cell ranges as necessary.
This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.
Hope this helps,
Hutch
"eileenfz" wrote:
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)
|