sum

Help! Maybe I am overthinking this. D5 has an =sum calculation. If it returns between 1 and 20 I need D6 to show 1. If it returns between 21-30 then D6 returns 2 and so on with different ranges. Only about 5 total with the last being greater then 100 returns 5.

Hello - I have lines of data (about 7,000) that contain a dollar value ranging from $0.00 to over $1,000. I was hoping to create a formula that calculate the $range the value is in. Example, if the cell value was $13.50, the formula would return $.01 - $25. $350, would return $300 - $400, $0...

Hi All, I'm trying to remove duplicates and sum values. I have table which is looks like that. item number client Date Quantity 167 C10000038 28/01/2022 00:00 3 600831 C10008630 27/01/2022 00:00 1 600831 C10008630 27/01/2022 00:00 48 600827 C10008630 28/01/2022 00:00 1 950114...

I have a dataset of product sales by period and customer. Every new period data for that period is added to the dataset (i.e. the dataset has cumulative information in it). Every period a report is prepared for each customer showing product sales for the period and the year to date. So period...

Hi, I totally new at VBA Macro and I just got the task from my work to do some. There are 2 commands that I need to solve: 1. I need to merge / copy as value only the first sheet of every workbook 2. The next thing is that I need to sum for specific cells of the worksheet, whenever I need to...

Hi, thanks for reading this post! (1) I have a table with the data, like this: Client Salesperson Sales ($) Google Mike 1,000 Apple Jim 5,000 Apple George 4,000 Apple George 3,000 ... ... ... (2) On another sheet, I'm creating a report, like this: Client Frequent/Max...

Hi, Does it possible to generate result in Column H? From the past data, the max positive value appear (>=0) is below 100 row. My data range between 250k-750k row...

Hi Guys, I have a huge excel table with 100+ columns and I'd like to summarize only the values from every third column. There is a solution for this? I summarized one by one but almost every day new columns are added and I have to extend the formula after each change. Thank you in advance! Gabor

Hello, I am trying to build a list by copying in logical order the rows from 3 tables containing: Existing stock, Sales orders Purchase orders for each item in inventory. Since there is no other available sorting criteria (no dates) the VBA should get the available inventory, then a...

I have a excel sheet, where in B column I have range of information, In D column I want the sum of that range of that sheet, In A column I have the sheet name. and in each sheet I have information in C column. So for the first row the formula is =SUM(A!C1:C69)+SUM(A!C75:C76)+SUM(A!C80:C80), is...

I have two columns, AR (Program Name) and BA (Yes or No), and I want to count the number of 'Yes' responses based on the program name. I've tried COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, SUMPRODUCT without success. I get returns of 0, all the Yes', and #VALUE. I've been trying to...

Hi all, trying to sum up across multiple sheets. Caveat: the cells being added up are all the same cell address as the active cell, just on different sheets. My troubles: I'd like to be able to insert rows or columns across all tabs and have the formula adjust to always be summing the equivalent...

Hi All, Very familiar with the ins/outs of using complex array formulas, but found the strangest issue with SUM not summing the numerical contents of the reduced array, e.g., =SUM({0,0,1,0,0})...and this produces a zero. However, it works as intended by entering it as a standard formula (just...

Hello. Looking to calculate the difference between 2 numbers, up a certain max amount. Example: I want to find the difference between 200 (A1) and 100 (A2), which is 100 but allow the formula to give me the difference up to 80, meaning return '80'. But if the number in A1 was 150, and A2 was...

Hi, Required a formula help to as per data available in working sheet, return a sum values in column C as based on task ID and Ledger by ignoring duplicates whatever available in column A and B (task ID and Ledger) in the summary sheet. Expected results are available in summary sheet column E...

Hi all. I'm attempting match col A with embedded name on column E. so far i have extracted the match, but I want to add up all the values pertaining to the hardcoded list in A:A. also the number after the name is always one space apart from the end of the name. like "dsgdf 100" See below...

Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...

QT 1g 2g 3g 5g 8g 10G 15G total 0 15 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 3 0 19 0 2 0 0 0 0 0 75 0 0 0 0 0 0 0 75 I am basically trying to find the sum of the different sizes of plants. There is a XLookup where it feeds the numbers in from a list, but the total is where I am...

Hi All, I have a sheet in which I need to sum values based on condition that these cells need to be highlighted/filled with a color and it should be visible in filter. I found following code which is working for Highlighted/filled cells but it is summing up all visible and hidden cells...

Hi, I am trying to calculate the maximum sum of values within an hour in column. Because the number of values within an hour isn't constant (see my example below) I'm having a lot of trouble trying to get this to work. As you can see in the sheet below, the times are in column A and the value...