| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a product key for my Trail product, 2007 Microsoft Office s | Setting up and Configuration of Excel | |||
| How to write a function for column A = product of two columns, B a | Excel Worksheet Functions | |||
| SUMIF/PRODUCT & DATES | Excel Worksheet Functions | |||
| SUMIF/PRODUCT with multiple Criteria not working | Excel Discussion (Misc queries) | |||
| how to write 'not equals blank' criteria in SUMIF | Excel Worksheet Functions | |||
Threaded Mode
