# 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