sumif and sumifs

Hi I'm looking for help on this formula. Tried looking for resources everywhere with no success. Please see the attached. The goal is to calculate the YTD totals of all the months for each of the the respective employees (i.e. Bob, etc) and each category (i.e. Bonus, Salary, Gross, Tax) I am...

=SUMIFS(AD2:AD1000, AF2:AF1000, "*123*") The formula above is supposed to find all combinations of 123 in column AD and sums up the corresponding cells in column AF. By combinations of 123, I mean: 123 132 231 213 312 321 The code just returns the value "0" to me. What can be done? Take note...

I am trying to aggregate a PivotTable's subrows, depending on that cell's associated grouping. Next to my Pivot I have a VLOOKUP helper column that gives the individual project's umbrella grouping, and another helper column to put the team name on each row. I believe using SUMIFs is the right...

Hello, I am trying to SUM only the value (in USD) of a cell that also contains a specific text. Please help, I ran out of ideas :) Here below a screen-shot of my cells.

Hi all, My name is Arth and I am having an exercise where I have to make a consolidated file of actual vs. budgeted expenses for a particular month in a year using numbers from multiple tabs that are not orderly listed. In some cases I have to get the number that I need by dividing a number by...

Hello, I currently have these formulas that calculate data from another tab's table, but if I filter data out of the table, my formulas still calculate the filtered out data. I'm pretty new to excel, but I've read a few forums on using SUMPRODUCT to get the results I want but not sure how to do...

Hi I've got a formula that's not working, as expected. Please find below a very simple sample of the data and formulae I've used: If you copy and paste the data below, it should go from cell A1:H7. I'd like to use a sumif to do two things 1) get the weight of the "Promo sales" for each...

Hi, I have a formula as follows, which works fine. SUMIF('Overview report'!$AK:$AK,"Yes",'Overview report'!P:P) However, I also have a dropdown in cell O10 with a choice of seven values, and column AK in that formula is appropriate only for the first dropdown option. So if I have chosen the...

SIR, I have done SUMIF formula which is working but I need a better suggestion for this so I have 4 different sheets of raw data and total (summary) of this sheet in Rec.sheet...

Hello, I have a huge spreadsheet that I am trying to do a summary on. I thought using a SUMIFS formula would work but I just can't seem to get the correct formula, I keep getting ERROR messages. Any help would be greatly appreciated. Please see structure below. <tbody> Current Spreadsheet...