sumif

Not 100% sure where to start here. Once B11 equals $1,400 I don't want the sum(B6:$M6) to continue to be calculated. Prior to D6 being negative B11=$1,400 and I want it to stay $1,400. I hope I made that clear enough.

Hi, I need help with a formula and keep getting Spill errors. What I am trying to do is say if the range A1:A100 = Anthony and E1:E100 = 1 (on another tab) then add H1:100 (on that other tab) that meet that criteria and divide by B15 on tab where formula is entered. Basically I need this...

I am trying to do a sumifs, but Column AD has duplicates, how can i tell this formula i only want unique pitch numbers?

Hi All, I'm having difficulties figuring out what function to use in the OUT column (B) to calculate the following: If the number in OUT (G) is greater than the TOTAL C then it should only show the MAX of TOTAL (C) otherwise subtract the remainder from the next instance of the colour (A) Blue...

Hi I hope you Excel masters can help me, it may be a simple thing i have forgotten I have a sheet (called full works) with a project column (column B) and a total column (column H). I would like to add column H if a certain field is in column B the below formula works when it is the same...

Hi all. I got a sum if function, that looks like this: =SUMIF('(PATH)'!$F:$F;">"&(EOMONTH(TODAY(); -1)+1);'(PATH)'!$H:$H)/1000 But it generates an error, because of the closed workbook. Can somebody help me create a SUMPRODUCT or SUM(IF - function?

Hi I want a formula that will sum data in a range based on a set criteria and I’m struggling. I have 1 - 100 data sets that I want to total 3 different columns with. Currently my formula reads = sumif(acc!$d$4:$ec$4,’FWD’,acc!$d5:$ec5) and that’s working to give me the total for all 100 data...

I have a database with auto generated data. On a separate sheet in the same workbook I can pull the information I need with SUMIFS but in a certain situation I need to multiply two cells first then sum the answers together without adding another column and divide by 12 to get Feet.

Hey guys I seem to be stumped! I have a spreadsheet and I am trying to get a value in an individual cell based on two rows of data on two different tabs and then multiply by another row of data :oops: Sheet 1 has column A, 63 lines with numbers column B, 63 lines with numbers Sheet 2 has...

Hello, someone knows how can i sum two coulmns in sumif? explenation - if range B3:B1700 = B3 ,then sum coulmns "W" and "X" (im in cell Y3) thank you!

hello :) I can't figure out how to the following thing - If the value of cell D9 appears in column AG in sheet 'pay' THEN only where in column AF in sheet 'pay' = "paycheck" sum the numbers from column C in sheet 'pay'. hope I was understandable! it's like first of all search the...

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