sum a column

Hi, i am working with two tables. Table "Sum" looks like this. Priority 07/08/2024 08/08/2024 09/08/2024 10/08/2024 High 5 10 8 12 Medium 10 20 15 27 Low 30 15 27 13 none 50 81 38 67 The Table "Raw" looks like this Priority 07/08/2024 08/08/2024 09/08/2024 10/08/2024...

Hello Mr. Excel Community, I'm seeking assistance with accurately reporting my team's overtime based on an HR report that presents some challenges. The report details hours worked, but employees may record their hours differently, leading to some inconsistencies. **Business Rule Overview:** -...

Hello, As this is my first post I apologize if this has been answered previously, I am new here and was unable to find any similar posts. Let me catch you up on what is happening in the background as to why I need this function. I am running Windows 11 operating through Office365, however my...

Dear All, In the below pivot table I dont need the monthly sum of GM (Which I have marked with a cross symbol). However I need a total at last ( as shown with a TICK symbol). Is there any option to do this? Please note that I need the monthly revenue and cost figures as it is. Only the GM...

Hey, I've been struggling with creating a formula to sum a column based on 2 conditions. I need to match the contents of 2 columns AND match the contents of another column against text in another column. Details: SUM Column C IF Column E value is found in Column B AND the text in Column A is...

Hi all, I am not sure if this is possible the way I want it, but figured it was at least worth picking the much smarter brains in this forum. I want to put a sum total at the bottom of a column. But, the number of rows in that column will change daily. Lets say it's in column A. One day there...

So I have a Power BI screen that i created via Power BI desktop and the connection is to SharePoint Online List. I have on my screen 3 elements, a) date slicer to select the date range to b table, B) Table, dynamic filters the data based on A date slicer. C) a card visual to sum the total of...

I'm working on a break list for my team at work. I want a very simple calculation to count the values in cells and return their number, with the text "currently on break: " in front of it. If I just use =SUM(C4:C16) it works perfect and returns me the number, but using ="Currently on Break...

Good Morning I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet. Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the...

I have two sheets, Sheet1 and Sheet2, There are 3 categories in my sheet A category, B category, C category. Under each category there are 5 sub categories and they are 1st year, 2nd year, 3rd year, 4th year, 5th year. In a column for example I have some values and I have the sum of the values...

I'm stumped on how to automatically sum data from a rolling report. The report I'm using is pre-set and only comes back in 1 format, with the criteria I need to use across the top with my sales cascading below. I want this to automatically calculate last week's total sales whenever I put the...

Hi there - I'm trying to sum all of the data in column D that have either a yes in the primary or secondary category, but only include the first instance of that value. In the example below, the sum would be 3 (1 for A, 2 for B). Please help!! :) <tbody> Area Primary Site Secondary Site Value...

<tbody> Name Department Wages 401K Smith, John Admin 10,000 200 Lavine, Avril Sales 500 10 Turner, Ted Admin 100 10 Fonda, Jane Sales 750 75 </tbody> I want to use an index match/sum if formula to sum the 401K column. The problem is that my data's columns maybe in a different...

Hi, Newbie need some help, <tbody> EXTRAS Colour <colgroup><col></colgroup><tbody> 2x25002770, 1xPAD, 1xWindow, 2xInso </tbody> <tbody> Slate Grey </tbody> 1x25005100, 1x25002770, 1xPAD, 1xMotor, 1xWindow <tbody> Mountain Blue </tbody> <tbody> 2x46004100, 2xMotor...

Hi Forum, example: <tbody> a b c d e 1 2 5 6 7 8 sum (e5:e8) </tbody> suppose above is the data on sheet 1 I want to find out sum of last current region of column "E" starting from "5" to "8" since I am new to...

Hey evryone, I have question regarding following issue. My pivot table looks like this: <tbody> Month Asset Order Sub parcel for order Occupation of asset Occupation for one order Month sum Jan S2 A prod A 21:30h 21:30h ??? Jan S2 A prod B 21:30h 0 ??? Jan S2 B prod A 10:03h 10:03h...

i am stuck here with a formula, i need to do a special sum formula, i need it to be as variable as possible. so the issue is that i want to sum the production on different operations every operator has a different number of operators so first operation i want to sum at cell E6, rows from E1:E5...

Hi, I new to this site and this is my first post, generally i poor in excel so please guide me on this Thanks in Advance. Red Highlighted valve are outcome of the formula This formula need to read two column (WS and R/F) at the right side, Both Columns are manually entered, outcome is total...

Hello, I'm tracking truck deliveries. I have a dynamic data set. I want to consolidate the data and sum duplicate lines. Below is my example: <tbody> CONCAT Code Delivery Date Customer Origin Destination Line # Carrier 7/6/2017 Oil Co. Houston Dallas 1 Energy Transport 7/6/2017 Fuel...

I have a task to solve in excel for my homework. I have a table with 9 columns with different values of whole numbers. I have to sum up each column and if sum is larger than 1 digit all except last digit shuold be added to the sum of the next column on the left. for example: If sum of column 9...