Get instant live expert help on sum vs product
“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
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 with a sum product formula tht
Solved by Z. U. in 23 mins
Up until recently, I've been able to use a period when using the Sum Function as in the days of Lotus. Now it won't accept the period and gives me a #Field! error. I went to Options-Advanced to ensure Lotus compatibility was checked....still nothing.....using a colon requires a Shift+Colon vs just a period....thoughts? =sum(A1.A2) vs. =sum(A1:A2)
Solved by K. W. in 18 mins
I need help writing a formula using sum product for weighted average
Solved by I. Q. in 16 mins