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 trying to find out how many people are working within certain times of the day with intervals such as 4:00-6:00. I tried using COUNTIF and SUMPRODUCT but they did not work
Solved by B. J. in 11 mins
I am trying to copy down this formula but I only want the G criteria to incriment and the rest of the formulato remain the same..... how can I make this happen SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A3&"'!B3:B105"),G8,INDIRECT("'"&A1:A3&"'!D3:D105")))
Solved by V. L. in 30 mins
Hi, I am looking for quick coaching on what I believe is the SUMPRODUCT formula, for doing a lookup that involves greater than or less than values in a target cell, to then return a specific value in a different cell. For example. I am measuring the value in B2, and depending if it is less than, equal to, or greater than a value in cell in c2, return the corresponding value from a table L4:N9. Kind of like a vlookup but different. Can you help with this? Should be quick and I am looking for assistance asap. Thank you!
Solved by M. J. in 11 mins
What I’m trying to accomplish is the following: I will be populating the weekly data for each week and location id (TOP PART OF THE SHEET). I would like to create a formula that adds each week on to its respective month and then add the Year to Date Column (BOTTOM PART). I have tried sumifs, sumproduct, index and match; but have not been able to accomplish that.
Solved by B. C. in 21 mins
Hi, I have a spreadsheet where I am required to use excel sumproduct function to determine the total revenue for product x for year 2017.
Solved by K. W. in 28 mins
How do I do sumproduct of all the rows that match certain criteria?
Solved by F. W. in 20 mins
I want to total the instances of football (soccer) matches ending in different scores at Half Time. I have 2 columns for HT score, for the home team and away team. I keep trying variations of countif, sumif, sumproduct if but if it works at all I seem to end up with a count of the instances of team scores rather than the instances of match scores, i.e. a 0-0 comes out as 2 (nils) instead of 1 (nil-nil)... add another score of, say, 1-0 and I end up with 2 or 3 (nils) depending on what I'm trying. I need a formula that manages to give me the instances of 0-0s, 1+ goals, 2+ goals, etc. In my file you can see where I enter score lines in the Scores tab... and where I need the formula in the Goals 4 tab - this currently is full of the formula that doesn't work.. except B4 and B5... I've just left it there in case there is an easy tweak rather than a full rewrite.
Solved by D. E. in 22 mins
I have a data set with values next to a variety of "Care types" listed on various sheets. I want to do a cumulative count of the sum of the values next to each specified phrase. I tried a SUMPRODUCT feature but it did not work. I also tried COUNTIF.
Solved by E. J. in 19 mins
I need a formula that will sum totals based on the month, but exclude any with 3 specific initials in the row. This is what my formula is now, but now I am trying to find a way to exclude certain row totals with the specific initials. =ARRAYFORMULA(SUMPRODUCT(1*(MONTH('2018'!$F$3:$F$34)=1)*'2018'!$AD$3:$AD$34))
Solved by B. J. in 13 mins
I have an existing budget model that was created years ago. I am trying to do a sumproduct function to calculate anything that matches "wages and salaries" in the rows along with anything that matches a specific date in the columns
Solved by M. F. in 26 mins