sumif

Hi all, I'm sure I'm doing something really silly with my formula however, I've basically got a table of total number of calls made per day. In column A I have the date, and in Column B I have the call number. I'm trying to calculate the total of the calls, made within a date range specified on...

Hi, to every one. I am creating a report. i have a list of different numbers in range M4:M21 What i need is to sum up any 3 or 4 values that can near to 240 but not more than that For Example I have This List Range M4 to M21 57 81 87 50 85 66 70 72 81 54 82 59 86 53...

I've collected some vaccine administration data that I want to analyze for unique patients in different age groups based on their registration date. So far I have used a Sum - IF - Frequency equation to determine the number of unique patients depending on the date the patient was registered...

I am trying to use a sumif with a sheet that has been set up with dyanmic arrays (see below image) I need to sum each column based on the flags "A,B or C". Is anyone able to suggest a formula that will spill and allow me to do this?

I am looking to group a list of numbers based on their sums to a target value. The database is large and would need to be a scalable solution. For instance, if my target value was 10, this would look like the following: Item Value Total Group A 4 I B 3 I C 4 11 I D 3 II E 2...

Hello, I have the following code which (should) create an array. Function UnitCheckArr() Dim UnitValueArr(2 To 250) As Long Dim UnitValue As Long For UnitValue = LBound(UnitValueArr) To UBound(UnitValueArr) UnitValueArr(UnitValue) = Cells(UnitValue, 4) * Cells(UnitValue, 6) Next UnitValue...

I have a Google Sheets workbook with 2 worksheets. (I suspect the solution is the same for Excel or Google Sheets, and if need be, I can switch to Excel) Sheet 1 lists about 1000 items (components). The list could grow. Sheet 2 lists some products (200 or so at the moment, but the list could...

Is this possible on excel? I have for example a file using vlook up function. source file is like this SI-1001 10 SI-1002 20 SI-1003 30 SI-1004 40 SI-1005 50 SI-1006 60 Now i need to look up this SI-1001-1004 vlook up all making the result be...

Hello I am building a tracking sheet for finance that will track savings over 10 fiscal years against our plan. I have 1 sheet with our plan, a second sheet where I am tracking ongoing actual savings we capture. What i was looking to do was create a sumif statement that would look at my...

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 =...