sum

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 everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...

Hi All I need to be able to create a formula to find out the number of units that are ordered on each day of the week. When a customer inputs a number into the day of the week column (MONDAY/TUESDAY) they are inputting the number of cases they want to order. I need this to then multiply by the...

New question for everyone, I'm trying to sum the prior month balance of all loan ID that are no longer in my current month as it was paid off. I can use this formula but adjust some values right? For some reason I get it to lookup all balances. =IF(Table2[@[Loan ID]]<>[@[Loan...

I am trying to figure out how to only look up ABC stock to calculate dividends only. Column B: indicates whether it is DIV, BUY, SELL Column C: name of stock (ABC stock) Column J: $ amount R3 = the lookup value aka stock How do I change this current formula to only include DIV for ABC stock...

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

Hi, I have a list of codes (column A), and amounts of money (Column B). I would like to sum all of the codes but where the codes are the same, only have the sum for the first instance of that code from the list. eg see the example below TIA CODE AMOUNT RESULT CAT 5 11 DOG 6 16...

Can anyone help please? For some reason the highlighted tab is shown 174 but I want that the number on this cell does not exceed the 173.33, so he maximum number will be 173.33. If the number on the red tab will be changed to 176 then the formula will work perfectly

I've been racking my brain trying to figure out a formula for this. I've included borders to help illustrate what I need. I'm trying to sum column P based on the month in Q and subtract it from the debited amount in column S to get my monthly total in column T. I tried doing a SUMIF but as...

I need to compute the total time in which a system was down, and it looks like using the SUM(C1:C20298), it's not working for me, it's giving me some results that are not accurate.. The problem is that I have random timestamps like 17:27:22.432, then 08:04:25.532, and those are over 24h, so it's...

Hello Excelers, I think a sumproduct is the solution but honestly I never understand how they work :( If sumproduct does work, would you mind explaining how the formula is built/how it is working? I want to add up stage 1 - 4 if it is between a certain date, say 01/09/2022 and 30/09/2022. I...

Hello, I am trying to update a macro that someone else wrote and I cannot follow the logic. Currently this macro will total/format cells within defined sections of rows between columns I and O. However, we have added a column and now we need the macro to change to do columns J to P instead. We...

Beginning of month 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 Net working days 21 20 23 21 22 22 21 23 22 21 22 22 This part data and I have a separate sheet where I am gathering data for each month...

When I type past the end of the cell my text is spilling into the next empty cell (the cell in the next column, not row). When I add a sum to the cell, it wont spill into the next cell and just cuts off at the end of the first cell. Any reason why this may be happening and how to fix it? Things...

When I type past the end of the cell my text is spilling into the next empty cell. When I add a sum to the cell, it wont spill into the next cell and just cuts off at the end of the first cell. Any reason why this may be happening and how to fix it? Things to note:- The next cell is definitely...

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

Hi, Thanks in advance for any advice on this. I am trying to get one cell to calculate a sum in a range of cells up to the cell/column that has a value on another row. Please see my example below: A1 should sum values in B1:E1 based on the last column that has a value in row 2. In the example...

I am looking for a Formula that will count a price based on the selection of a few Radio Buttons. So for instance =SUMIF(B1+(Radio selection 1=1, then add B2, if radio selection 2=1, add B3...etc I know this isn't the correct use of SUMIF but this is the essence of what I am trying to achieve...

Hi Team, I have 15 members in my team and they are updating their volume details for each sheet (I created one sheet per member) I have to create a summary with the help of pivot by using all the sheets(sheets will have same titles). Person1 Sheet will be Name Book ID Book Title Pages Count...

Hi, I have a column that is full of sum values from a data set. Then, I have another column that I set up to give me values based on this formula, essentially: (A1/$A$2) [it's to find proportions]. When I go to custom sort the table by the header in the formula column, the sum values get messed...