Get instant live Excel expert help with SUMPRODUCT Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am looking to create a SUMIF that works even when data is filtered. I know it's some kind of SUMPRODUCT but can't get it to work.
Solved by S. Q. in 20 mins
I have the following formula using SUMPRODUCT, but I need it to ignore text and in cells. =SUMPRODUCT((MOD(ROW(D4:D19)+1,5)=0)*(D4:D19)) I know the formula works, because when I change the text to a number, I do not get the #VALUE! error. Can you help?
Solved by C. S. in 15 mins
I need sumproduct to ignore blank cells, I'm looking it pick up values based on a row populated via formulas.
Solved by O. A. in 20 mins
Hey Guys, I have a problem. In my database, i have several injuries mentioned (eg.: head,half-head, nose, finger, hand, torso...), all injuries are written down in one cell. Most of the time, the medical personal writes down all parts of the body mentioned. I wand to find out, how many injuries in a special group of injuries have been attended within this year. Group 1: head, nose, eyes... Group 2: hand, finger, arm... With countif and sumproduct i only get the number per injury. How can i avoid double-counting? E.g. there are 25 injuries on half-head and 31 on head. (6 whole head + 25 half-head)... Thanks in advance!
Solved by C. B. in 30 mins
SUMPRODUCT FORMULA GIVES NAME ERROR =(SUMPRODUCT((Price_LC_Phy1)*(PHEI_Distributor=$B$3)*(ARP_BUCKET=$A$4)*(Rolling_12=$A$3))/SUMPRODUCT((Price_LC_Phy1)*(PHEI_Distributor=$B$3)*(Rolling_12=$A$3)))
Solved by A. H. in 12 mins
Hi, I need a formula to work out how many values are less than a certain time value, simple "countif" do not work as it is a filtered spreadsheet. Here's the formula that I have got so far: SUMPRODUCT(SUBTOTAL(3,OFFSET(Current_Month!N$2:N$10000,ROW(Current_Month!N$2:N$10000)-MIN(ROW(Current_Month!N$2:N$10000)),,1)),--(Current_Month!N$2:N$10000>"24:0:0")
Solved by K. L. in 26 mins
Hi I have a VLOOKUP / SUMPRODUCT formula I need to get working. It used to work before but some one interfered with it and now it does not. I usually can rectify but for some reason, I cannot this time. Cheers
Solved by B. Y. in 30 mins
I need help with sumifs or sumproduct to calculate a total time due to a certain factor.
Solved by C. C. in 16 mins
I need a formula that adds up 3 columns with a criteria in a 4th column, I've used sumif and sumproduct but can't get it
Solved by V. A. in 28 mins
I want a SUMPRODUCT() function to be used to sum the total of a range of rows between two dates.
Solved by X. L. in 13 mins