sum

I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...

Hi Like many others,i have a simple problem with excel/VB. I would like to calculate the sum of each dish ordered in one evening. To this point i have each order added up to an amount and then emptied again with a button. I had that cell copied to another cell so that it can be added with...

Please see attached image for sample sheet! I have data sorted by row H and I have a blank row in between each different group. In that blank row, I need to total the values in that group for columns I through O. I want to be able to run a macro do to this. I know I'll need to set the range...

I'm looking for assistance in setting up a macro to do the following. 1. Add a blank row in between each set of value from Column G. Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this - Bob Susie Susie Lauren Bob Lauren...

Hi all, Hoping someone can help me with this formula: {=SUMPRODUCT(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]"))} Which is returning 0 Or, =SUMPRODUCT(SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]")))...

Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...

Hi, I previously received some support on the following link Formula Support - Top 10 list using Index and Match, where i was directed to changing my formula to a LET function. The formula worked fine, but i noticed that it was pulling back multiple values with the same name, Is there anyway...

Hello, I am trying to SUM only the value (in USD) of a cell that also contains a specific text. Please help, I ran out of ideas :) Here below a screen-shot of my cells.

This is my homework : find sum of 31st - 50th even numbers between 1-100 by using either do-while or do-until loop. Pls help me

Hi all, I'm trying to find a way of adding a total value based on the selection of two different cells. These two cells have a drop down list, each of the options on that drop down list has a value: The first image shows the drop list on the cells, and the second is a different sheet with...

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...

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