sum

Hi I need your help in calculating the total sums of all the cells with yellow color. As per the example mentioned below are two columns mainly Name(C) and sales for the month (D) Now as you can see there are certain cells in the Name column (C) like C4,C7,C13 and so on which turn yellow. I need...

There might be a much easier way of doing this, but I'm struggling to come up with a solution. I have columns month, person and payments. A month can have multiple persons, and not all people need to appear every month. What I want to return is the payment sum per month as well as a sum of...

Excel Version = 365 OS = Windows Hi Everybody, Still New to the whole Power Pivot thing so please bare with me as I will have a lot of Obvious Questions that might seem stupid. Summary: I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date...

Hi, I need an solution in VBA to find Best combination of sum value or Nearest to sum value from the list of data. For ex: in A column A1 = 10 A2 = 20 A3 = 35 A4 = 50 A5 = 60 Given sum value B1 = 100 B2 = 85 Expected output from macro A1 = 10 B2 A2 = 20 B2 A3 = 35 B1 A4 = 50 B2 A5 =...

I am having an issue trying to find a formula to subtract minutes from hours based off the formulas I have used to sum the time remaining. I am trying to sum the times in E5 and E6 into cell E3. B5: =LEFT(B3,FIND(":",B3)-1) C5: =LEFT(C3,FIND(":",C3)-1) D5: =LEFT(D3,FIND(":",D3)-1) E5...

Hi All, So my question is how to show how many numbers fall into a specific range between 2 different numbers: BCDEF5Start numberEnd Number22-3031-4546+62429500733430100848680020943440101027564151011275731511 The yellow part of the table i have calculated manually and entered the numbers need...

Hi All, See my table test data. I want to show a total based on the cells that are <> Not in Scope. However I want to exclude OS Upgrade Status from the formula, so those cells do not add to the count. Any of the cells that have a DNS listed are highlighted green if that helps, but can not be...

hello guys , i have a data that include this columns , and i want to know the lowest and highest sale for city 1 in these 5 month , that's mean formula must sum the sale of city 1 for 5 month Individually and show the lowest sale ABCDEFGH1monthcity codesalecity codeThe lowest amount of total...

I have a spread sheet where I'm trying to get a calculation of a sum of two cells where their data is referenced from two other sheets. And I'm getting 0 as a result. What I'm trying to do is: in cell R10, I want R10 to =SUM(O10:O11). It should =80 but it's not. Formatting is the same on all...

Hello, I need some help with a split shift calculations. I have the data as below for Split shifts in an excel sheet, is there a formula that I can use to calculate the sum of total hours from 08:00 - 12:00 and then 16:00 - 21:00. Please let me know if I could achieve this by changing the...

hello, is this possible? I have a bunch of numbers in a column, lets say its from I4:I20 Now in I21, I want to get 20% of the sum of I4:I20 - is that possible with a formula? Now if yes, a potential added complexity... the range of cells will actually be different every time. BUT the constant...

Hi everyone, Please see below sample data set. The columns are always going to be the same, but the rows will be dynamic each time a report is run. ABCDEFG1Start01-May2End07-May34NoNameDateCategoryTypeDrCr515Name101-MayEntertainment-200690Name201-MaySupplies1500745Name301-MayTravel...

Hi Dear i am new to VBA. when i am doing test by pressing F8 my macros are running fine but when i am running my macros worksheet function sumif is not calculating its showing zero below is my macro Dim sht As Worksheet Dim shtName As String Dim i As Long Dim rng As Range Dim rng1 As Range...

Sorry but I'm back again.... I hope everyone is well and good... anyway I have 2 Sheet (Dummy and Updated) from Sheet Dummy my code would supposedly insert my Sum and CountIfs formula in the designated cell in my Sheet Updated, although it runs but the problem is the total value does not...

Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...

Hi there, Can anyone advise if there is a formula I could use here in cell C2. I'm looking for a formula to sum the values in column but only if they have been 'ticked' here in column B. So for example I would need Option 1 to return 1000, and Option 3 would be 3000. Any help would be greatly...

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