sumif

Excel Office 365 I have a pivot table with dates across the top in row 1, names in column A, numbers in the cells below each date for each person. I am looking for a way to provide a sum of the numbers for the dates that are on Friday, Saturday, Sunday while still keeping the other dates and...

Hi all, I currently have the following setup: Is there an easy way to SUM this for each date? I realize that I can do something like this: However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new...

Hi all, i've scoured the internet and have had no luck. I am hoping you guys can help. I am doing this in Google Sheet so hopefully some of you may know. I am trying to display the data/value from a cell that corresponds to a checked box from a different column and display into a new cell. I've...

Hi all, I have this setup at the moment: However, when I search for "14-06-2022" I get a sum of 9964136,14 because my SUM formula takes all the hidden rows into account When I plus all the numbers I get the correct amount of 372344,76 But it takes a lot of time to write "A1 + A101 + A102 +...

i currently have a spreadsheet that is connected to an oracle database ABCDEFGHIJKLM111/4/21 11:24 AM11/5/2020 11:2411:00 AM2:00 PM5:00 PM8:00 PM6:00 PM234 Time2022567Friday, November 4, 202211:00 AM08VIP 09Regular102:00 PM011VIP 12Regular135:00 PM39114VIP 15Regular168:00 PM14253317VIP...

Have a different tab for each security setup. Trying to create a sumif formula with the criteria range pulling a tab name from a cell for that specific tab. So for instance have the tab name Acala in cell E38, want the sumif to pull critieria from Acala!C:C, is there a way to make the formula...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

Hi Gurus, I would need your help on building a code that combines SUMIF and Vlookup on Excel VBA. I have a Table named StoreRecords, with one column for Store Locations and another column for Daily Sales. Now, what I'm trying to accomplish is to create a userform with combo box that will...

This will likely be long winded, I apologize now. (some data removed and names changed for NDA reasons) Basically I'm trying to sum these by the number in the middle, using the Plus/minus and Steak/Pastry/Apples. In the full dataset, the numbers in the middle repeat and are shared by pastry and...

Cells A-H in blue refer to workbook 'Dan Participants'. Columns A and B are linked to an external data source. I have used the CONCAT function to merge the names together from cell A and B. Cell H references the internal worksheet 'Vacancies', cells C and K coloured red. The formula works as...

Hi there! I am reaching out to you to see if someone can help me with this excel problem. Essentially I want it to look up two criteria, say, Depart # and Type of Pay (like Gross Pay); I want it to match each one and sum up all the amounts that match in that column to the department giving me a...

Hi, I'm looking for a formula that can look through a worksheet, find a value and add together the cells next to it. In essence I have a sheet that could have a value eg Oranges a number of times anywhere on it. What I would like to be able to do is have a formula that looks for all the...

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