Sum with offset based on Sl No
Sum is to be based on Sl. No field (image attached)
The formula in cells are as follows
E3 : ROUNDUP(D3,-0.1)
E4 : ROUNDUP(D4,-0.1)
E7 : ROUNDUP(SUM(D5:D7),-0.1)
E9 : ROUNDUP(SUM(D8:D9),-0.1)
E10 : ROUNDUP(D10,-0.1)
I wish the sum to be calculated in Col. E.
If there is a value in the next immediate row in Sl. No. field, then the value in Col. D is to be directly displayed after rounding off to next whole number in Col. E. Whenever “” is found below the next serial number, the values from that corresponding cell in Col D should be added till the last cell against which the next serial number is not present. The sum shall be rounded off to next whole number and displayed in Col. E (highlighted) against the last value in Col. D.
User-defined function in Col.E is desirable say sumfunctionrng(B:B, E:E)
Similar problem is mentioned in VBA - conditional Sum column B until change of value in column A
Try this in E3 and fill down.
=IF(OR(B4<>"", ROW(B3)=MATCH(1E+99, D:D)), CEILING(SUM(D3:INDEX(D:D, MATCH(1E+99, B$1:B3))), 1), "")
- List only workdays in given dynamic month
- How to read SharePoint Online (Office365) Excel files into Python specifically pandas with Work or School Account?
- Difference between .Delete and .Clear in Excel VBA?
- Merging cells in Excel using Apache POI
- Having issues not including duplicate words randomly populating 3 columns in Excel
- Excel: Filter a sheet from value in another sheet
- Merge two cells keeping/adding formatting
- Output all cell colors from a range in Excel using Office Scripts
- Using EPPlus with a MemoryStream
- Creating an office script where it looks at the first column in each sheet and inserts a column based on the value in the first column
- Putting a concatenate inside of a count if
- GetMyFeesEstimate API Amazon vba
- "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns" Error
- Excel fill numbers within a range
- VBA isString vs isNumeric
- How to use a cell range to color another one?
- Macro Help: Workbook to New Doc Copying Only the Cell Values
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel VBA Autofilter Values Not Equal To Asterisk (*)
- How do I check If autosave is on and then switch it back on if it is not?
- Driving Excel from Python in Windows
- VBA Excel Cannot open external workbook
- TypeError while using Openpyxl to read file
- Excel VBA to hide rows if more than 10 blanks
- I have a list of lat/long points of interest, and lat/longs for public trans how to find addresses with have all three public trans?
- Excel: how to search by two rows and one column
- Excel to Word VBA The formatting does not apply to the correct text
- Select some adjacent and non-adjacent column ranges and save to pdf as if they were all adjacent
- How do I convert a single vertical row into multiple row array in Excel?
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit