# 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 in excel; 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