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

NOTE: I HAVE A GOOGLE SHEET LINK I CAN SEND. HOWEVER, I CANNOT PROVIDE IT AS PART OF THIS LOG-IN (your system keeps preventing me from connecting) ISSUE: I am looking to create a summary table that dynamically calculates count formulas, sum formulas and sumproduct formulas (see an example of the specific formulas in row 8 of the worksheet titled: "Client distribution_by category") based upon the data presented on a pivot table in a separate worksheet (worksheet titled: "Client distribution_pricing". For transparency, I'm trying to avoid using a macro to do this, but not sure how to go about this problem. Thanks for the help!!!
Solved by O. J. in 30 mins
i heard that sumproduct can reference a closed workbook? if so how can i change my sumifs to sumproduct?
Solved by A. J. in 22 mins
help me make my sumproduct work, i get an error message saying my name is not right
Solved by O. H. in 15 mins
I need helps for excel problems from my school lesson. Solve the short three question and explain the problem solving. These are the questions. 1.1 Count the number of complaints initiated in May concerning the product family PF10 (using SUMPRODUCT with other possible formulas). 1.2 Display the name(s) of product family complained by the customer C9 as a wrong product (using VLOOKUP formula with other possible formulas). 1.3 Give the monthly average of complaints about the product family identified in the task 1.2 (using formulas).
Solved by E. U. in 27 mins
I need to count the number of complaints initiated in one month by using sumproduct.
Solved by T. S. in 15 mins
I need formula regarding SUMPRODUCT to find out the number of complaints initiated in one month.
Solved by V. S. in 12 mins
I need a formula that combines two separate revenue calcs together: (1) SUMIF based assignment of revenue based on calendar month/year; (2) SUMPRODUCT with SUBTOTAL that sums revenue by category
Solved by X. C. in 19 mins
Hello I would like to use a sumproduct and then be able to drag down, but problem is that the data that needs to be sumproduct are on the right rows.
Solved by D. Y. in 26 mins
I need help with this formula: =ROUND(SUMPRODUCT((MONTH(A2:A10413)=12)*(I2:J10413))/INT(SUMPRODUCT((MONTH(A2:A10413)=12)/7)),0) it si not giving me an acurate output. i have A1 with multiple dates I & J have amounts i need the formular to find all dates in the first month then calculate the number of weeks in that month then divide it into the total for that month from B & C colums to give an average for that month and so on for each month. Eg: Jan Date 1/01/2018 to 30/01/2018 = 4 weeks divided into B& C totals for Jan Feb Date 10/02/2018 to 30/02/2018 = 3 weeks divided into B & C totals for Jan
Solved by C. C. in 28 mins
While doing SUMPRODUCT formula, the alpha numeric is getting captured "1A" and the only numeric like "1" is not getting captured please help
Solved by V. W. in 22 mins