sumif

Attached image. I am attempting to create an input table where I input how many of each cake made, and an output table that calculates # of bags for each ingredient used. I know how to manually calculated this (Example: Vanilla cake has 300 cakes made, to calculate flour used [(300 cakes *...

Hi community- I'm looking for a formula to sum up working hours for various employees , grouped by Optician ID, if they had an active contract within a certain month. I've played around with SUMIFS, but I get an error message, that it's not a formula...

My Sheet1 contains data of which column B contains patient IDs, Column C - Date, column D - Contact No, Column E - fees paid on various number of days / visits. I want to gather data of sheet1 to sheet2 where column B will contain patient ID, Column C- contact No. and Column D - total fees...

Hi everyone I have created a proforma invoicing system in Excel for our landfill site. I have a sumif formula that calculates the total weight of each type of waste (General, mixed waste & large rubble) and then it gets multiplied by the tariff. This is on the "Region 1" sheet. Companies are...

Hello I wanted some help in calculating employee overtime and time-off in lieu. I have 2 data worksheets (“Original Saturday Overtime Hours” & “Sunday Overtime Hours”) showing the number of Saturday and Sunday overtime hours respectively. They can have more than one entry in each and not...

I have a workbook with 2 tabs that are relevant to my query, 'Workings' and 'Data'. On the 'Workings' tab I have an array of ~3000 SUMIF formulas that looks at ~12000 rows of data on the 'Data' tab. As this cumulatively looks at ~37M rows of data this is slowing down my workbook, so I want to...

Hi All, May you help me with below? Name in Column "H" will be the lookup value vs "A" and "D". Other condition is in the table:

I am having a brain fart. I know this is a simple formula but for some reason, I cannot get it. I have a sheet that has multiple information. I want to be able to do a sumif column "A (Period)" has 2021.01 and column "H (Ops Work Center)" has RVR101MA, RVR102MA, RVR103MA, RVR104MA, then sum...

Hi, I have this table (its spanish so decimals are commas) I want it to add items as a new total in G66 if the integer in column a is the same as the reference number in A66, but it seems it wont work on a range. =SUMIF(A14:A58;INT(A14:A58)=A66;G14:G58) Thanks for the help

Hi, I am looking for a formula to put in cells B2:F7 on Sheet 2. Notes - This is a simplified version of the file I am actually working with. The file I am working with has all work-day dates (Mon-Fri) in row 2 on Sheet 1, for 01/01/2021 to 30/06/2022. - Each Trade Reference is unique, so...

Sum units is expected result - there are over 2000 lines and i need to sum all per row with heading of "units" Sub GPSUM() Columns("k:k").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("k5").Select ActiveCell.FormulaR1C1 =...

Hello, I have in excess of 30 identically formulated worksheets that contain (amongst much other information) lists of stock, location and quantities in different columns. I want to create a single summary page that searches through all the worksheets between a Blank Start worksheet and a Blank...

Hi all, i want to sum only numbers contain 15 in range. all data are in number format. Example is attached. Thank you very much in advance.

Hi, I have an issue with a colleague of mine. I have created a report for her which works fine on my laptop (Windows 10), and also my other colleagues laptop (also windows 10) however when I send it to her (Windows 7) she gets a #name? error in some of the SUMIF fields, however a majority of...

I am new to spreadsheets and have no training. My knowledge is very limited. Screenshots of the spreadsheet I’m creating are attached. I am attempting to total all miles and fuel by state on sheet “Quarterly IFTA Report” for all the sheets between the sheets “Start” and “Stop” Additional sheets...

Hey guys, I have looked online and have found some similar questions related to this, but nothing I have found seems to work. I am trying to use a SUMIF statement on a large collection of data. For the most part, it works just fine. However, if there ever happens to be a blank cell in the...

I know using SUMIF would work if I selected the cells with the ":" such as: G7:G106. However, I only want to sum multiple (specific) cells if they are more than X. If, for example, I want to exclude G7 because the number is negative and only sum the other cells, I run into a problem. Here's an...

I have made a formula which corresponds to certain components. I need to make this formula for each day of the year for 9 components, using information from another worksheet in the file. However the cell range is from e.g. 1:23 for the second day it is 24:47, so forth. I cannot drag this...

Hi, Looking for help to calculate the number of instances wherein a assigned limit has been utilitzed greater than or equal to 90%. ColA having Date ColB having Individual names ColC having limit utilization in %age and ColD having Instances (the desired output). Case: If individual (Tom)...

So I have date in the format Value Start Date End Date 40 14/10/20 05/11/20 50 01/10/20 31/10/20 Assuming the value can be spread evenly over days, I want a sumif function that tells gives the following output (ie for Oct, 17 days of the 22 days of 40, PLUS 31 days of the 31 days of...