sumif

Hello, I am trying to figure out a formula to work out the cost of ingredients in different stores and then also look at the cost for the whole recipe at the same time. I have an example with really basic amounts in it just to give an idea. I have built it with a really basic =(A1 * I1) + (A2...

Hi, In the following formula I have type in the "A2:A6"; SUMIF(INDIRECT("'"&Sheets&"'!"&"A2:A6"),"a",INDIRECT("'"&Sheets&"'!"&"B2:B6")) Sheet = named range is there a way to have the reference to A2 to A6 in other cells so a cell A1 = "A1", A2 = "A6" and then just select those two...

I have an excel where I need to pull in the total hours for a date range (always start on Monday) in my excel tab called 'Dashboard'. I'll be getting the data from the tab 'Budget' but I only want to pull in the number based on the QuickBooks Code I've identified on B1. So AH3 will equal to...

Hi there, I have two tables for labor rates by function and by year. One table for GBP currency, and one for USD currency. I then have a table that contains labor hour requirement by contract (many rows). Each contract is either native to GBP or USD. I'm trying to use the following formula to...

Hi all, Hope you can help me with the following issue. I want to calculate the average number of grounds in a selection of cities (E2:E4). In this example, the number of grounds per city are given in column C. However, I don't succeed in getting the correct number, because it takes into...

I want to sum if certain cells if the corresponding cell is marked with "Y" and if they are marked with "N" or left blank then subtract the amount in the corresponding cell. I am sure this is not hard to write a formula for but I cant figure out how to do it. Any help would be appreciated!

Is there a way to map a formula to make it smaller and not so large, formula below? =SUMIF('TB'!A:A,"4254",'TB'!D:D)+SUMIF('TB'!A:A,"5445",'TB'!D:D)+SUMIF('TB'!A:A,"5446",'TB'!D:D)+SUMIF('TB!A:A,"5447",'TB'!D:D)

Hi all, Hoping someone can help me with this. I'm guessing it super simple, but I can't find a solution anywhere online. Basically, what I'm trying to do is count the number of times each cell in a range (G4:G9) is not blank and is less than 70% of the value of the cell that is 2 columns...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hi, I am trying to sum up the amounts belonging to certain categories through their ID number but cannot think of any way to find all matching items - xlookup only finds the first item and I can't have a spilling function like filter. The ID number/amount table and ID No./category table must...

Hello, hope you can help. I would like to use a formula to give the count of complete projects in [time range] where there is a total of <=1 hour spent on 'review' over the whole project - example sheet below. In this sample the desired answer is 2 as only project A and B meet the criteria...

Hi, I have a collection of cashflows which I am looking to consolidate onto a master sheet (all within the same workbook). Each individual tab has the same account code and date references. I have a name range for the individual tabs but I cannot seem to find the correct syntax to pull the...

Hi have the below formula i am trying to edit the outcome, =SUMIFS('Annual NEW'!$T:$T,'Annual NEW'!$B:$B,L$5,'Annual NEW'!$E:$E,$E143,'Annual NEW'!$H:$H,$F143) i am trying to find a way that if those criteria's are met then the sum should be Column M + N + O + P and a similar case where...

Hi everyone, I have a question with two columns: if a column of mine holds a value such as "100 012", "800 002", "500 012", or "800 004", and my second column or updated value holds a value such as "800 007", "800 008", "800 003" or "97", I want the balance of that specific row. Realistically I...

Hey Everyone, I'm getting a little confused on writing this formula. This is what I have: =SUMIF(F9:F25,"*BMO*",K9:K25)+SUMIF(G9:G25,"*BMO*",K9:K25) This is what I need to add: My range is currently set to K9:K25, however I want the sumif range to use the value in J9:J25 instead when there is...

I have a table with 3 columns: transaction date, costs/revenues, tax/deductable tax. Each row is one revenue or cost and the dates goes on multi-year seamlessly (i.e., I have a table that has this from 2019). What I'd like is to give a date in a cell (say A1), and have a formula that outputs a...

Hello Sheet 1 Sheet 2 In sheet 1, I need to know how many times each SMT has someone absent with 1 occasion, 2 occasions, 3 occasions and so on summed from sheet 2 So, using the above examples, Bob would show In the above example sheet 2, I've collapsed some columns to protect private...

Hi, i have this table (could not upload mini sheet) on multible sheets week is merged cells but here i have just wrote 1/2 in all cells Week: 1 1 1 1 1 2 2 2 2 2 user aa bb cc dd ee aa bb cc dd ee task 1 1 4 2 3 2 2 8 4 6 9 task 2 3 5 9 3 2 7 4 2 8 3 sum...

Hi, I would like to sum data in a column based on the results of 2 other columns. Machine 1 Monday 3 Machine 3 Wednesday 2 Machine 2 Monday 5 Machine 1 Thursday 7 Machine 1 Monday 6 So i need to sum column C in a table Machine 1 Count Machine 2 Count Monday Monday...

Using last years actuals for January and February and using this years January results +February forecast. If the customer's year-over-year variance is positive they are label as a gainer, if their year-over-year variance is negative then they are labeled a decliner. This is the formula I was...