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

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