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

Need help with google sheets, im stuck using the sumif formula

Solved by V. J. in 23 mins

Sum and Average across multiple sheets. I'm quite adequate with excel but can't figures out how to do sumif and averageif across multiple sheets.

Solved by B. W. in 30 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

simple sumif problem that I just cannot figure out.... please help

Solved by K. H. in 24 mins

I need to use the SUMIF function dynamically in VBA. For the range, I have tried to build the range: "$C$2:$C$" & lastRow, but it does not work. I then created the variable: MyRange = $C$2:$C$ & lastRow and then I place MyRange in the SUMIF formula. Nothing works! An example of code:
lRow = Cells(Rows.Count, 3).End(xlUp).Row
myAddress = "$C$2:$C$" & lRow
MsgBox TypeName(myAddress)
Range("I:I").ClearContents
Range("I1").Value = Month(dtDate1)
Range("I2").Select
ActiveCell.Formula = "=sumif(myaddress,h2,$e$2)"

Solved by T. D. in 25 mins

In this problem, you must first complete the Sales table below by entering equations in cells C22, E22, F22, and G22 that can be copied and pasted down for each sales transaction. This will require the use of the vlookup function to find the price and the discount. The net column should be calculated as Total * (1 - Discount)... Next you will need to fill in the totals for the green shaded cells at the bottom of the table.
Once you have completed those tasks, the goal is to create a formula in cell D18 that will use the sumif formula to add up the net amount of sales to a particular customer... If the customer filter is blank (which can be tested in the if function by using B15 = "") then your formula should sum up the net amount of sales that satisfy the relationship specified by the Net Amount filter and the operator... For example, you may want to see what the sum is for transactions with a net amount in excess of $3,000. In that case you would type $3,000 in cell E15 and select the symbol > from the drop down box that I have already created for you in cell E16. If both filters are blank, then the cell D18 should just return the sum of the net column. To reiterate, your formula should first check to see if cell B15 is blank, if it is not, cell D18 should return the sum of all transactions for the customer ID listed in cell B15. If cell B15 is blank then your formula should check to see if cell E15 is blank, if it is not, your formula should sum up all transaction based on the amount listed cell E15 and the operator in cell E16. Finally if both Filters are blank, then the formula in cell D18 should just return the sum of the net column.
To accomplish this task, you will need to use the IF function and the SUMIF function as well as one of the two methods of concatenation to fill in the cell D18.

Solved by X. W. in 18 mins

Hi there, I am trying to create an average. I have my range, my criteria and my counts but it returns zeros. I am trying to count the average unit per person
My range a column including all those names, my count is a column counting each line with a number in and my criteria is the 7 names. I created a sumif formula and another formula. Will I be able to share the file with you? So many thanks. I have the felling that there is a filter on the file. Would this prevent the calculation to work? Many thanks

Solved by Z. C. in 25 mins

I need a formula to put in the column B in the COST SUB TAB, calculating excel table subtotal per resource from Column B in the Cost Plan tab (the result needed is similar to a Pivot TableNot with Resources in the Row and the Sum ofForecastedUnits in the values, however i would like a formula instead the pivot table for a similar result).
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.

Solved by F. D. in 29 mins

I need a formula in the 2nd tab, to calculate the subtotal per resource from the 1st tab.
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.

Solved by V. E. in 27 mins

I have a spread sheet i keep up with the hours by staff works. I have to calculate end of shift overtime. other than manually adding up the excess time over 12 hours i would like to be able to have excel add up the total hours worked over the 12 hours. so lets say i have 12, 12.25, 12.5, 12, 13 in each cell. the SUMIF will add up the cells greater than 12 but I only want the .25, .5 and 1 added (which would give me the end of shift overtime i need) is this possible?

Solved by D. A. in 17 mins