sum

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

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.