AboutPricing

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.
< Go Back

    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
    124