sum a column

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

Hi, I have the following list of data:- <tbody> A B 7 750<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Verdana}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Verdana}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...

I have a list of data, column A is a unique identifier, column B is a number. I already wrote a macro that every time the value in column A changes to insert three rows. I then manually go to column B and sum the total of the rows. The number of rows for each unique identifier as well as the...

Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns according to date. And I have another sheet which is the chart sheet. I want to populate the chart...