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

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