Get instant live Excel expert help with SUMPRODUCT Function

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

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")))

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!

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.

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.

How do I do sumproduct of all the rows that match certain criteria?

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.

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.

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))

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