Get instant live expert help on sum to product formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
WHAT IS WRONG WITH MY FORMULA? I KEEP GETTING AN ERROR MESSAGE =IF(O3>0.0001,(IF(G3>65,IF(H3="M",(PRODUCT(SUM(140,-G3),K3))/(PRODUCT(72,IF(O3>1,O3,1))),((PRODUCT(SUM(140,-G3),K3))/(PRODUCT(72,IF(O3,1)))*0.85)),IF(H3="M",(PRODUCT(SUM(140,-G3),K3))/(PRODUCT(72,O3)),((PRODUCT(SUM(140,-G3),K3))/(PRODUCT(SUM(140,-G3),K3))/PRODUCT(72,O3))*0.85)))),"")
Solved by G. J. in 14 mins
I need help with a sum product formula tht
Solved by Z. U. in 23 mins
have two product use lists and I want to be able to count/sum the adjacent cell numbers to get a total product used. product # | # of products product # | # of products want to sum the (# of products) by the (product #)
Solved by C. J. in 12 mins
I need help writing a formula using sum product for weighted average
Solved by I. Q. in 16 mins
I need sumifs formula if I change Account, Product and Category sum all the data found in F10: F30. I have in B2 account name (range A10: A30), B3 product (range B10: B30), category in D2 (range D10: D30), to be sum in F10: F30.
Solved by M. H. in 27 mins