excelsumdivide
Sum divided series
I wanna ask you. I have value which I want divide and sum. I will give you example: Which I want series sum
A1 Value 5 B1
A3 Count 4 B3
10,41666667 **B5**
=SUM(B1;B1/2;B1/3;B1/4)
I want when I change count value formula will calculate automaticaly as formula "=SUM(B1;B1/2;B1/3;B1/4)" Count value continues up to n, formula should work even if count value 1000.
Please help. I hope so I could explain.
Solution
Try this formula
Formula used in cell B5
=SUM(B1/ROW(INDIRECT("1:"&$B$3)))
Or you can use SUMPRODUCT Function as well, to avoid the CTRL+SHIFT+ENTER
Formula used in cell D5
=SUMPRODUCT(D1/ROW(INDIRECT("1:"&$D$3)))
- ODBC error when trying to connect MS Excel to SPSS file on fileserver
- No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
- In Excel, create table showing the row,column of the cells in another table
- How to connect to MS Dataverse using ADODB Connections in VBA
- How to reliably increment a Character+Numeric value in excel
- REDUCE with conditional VSTACK inside LAMBDA. Is it possible?
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Incorrect comparison result with calculated date
- How to ignore empty values in a column in Excel VBA?
- Looping through rows in Excel to assign a counter to different rows
- SUMPRODUCT with TEXTSPLIT and MATCH formula returning #VALUE! error when summing multiple intersections in Excel
- Add new button to worksheet with Excel Add-in
- Using VBA in Excel to Google Search in IE and return the hyperlink of the first result
- How to open excel file fast in Python?
- List all values of overlapping dates
- Using a variable to set a userform object name
- Remove 'The ' from the beginning of a book title
- How to enter information in one cell based on text in another cell
- How to create a Excel formula for converting Cell value to Hexadecimal number?
- retrieving data from table but getting "compile error: expected ="
- Update open read-only version of shared workbook to show saved changes made on editable version of workbook
- How to show current user name in a cell?
- Which Regex replacements help when rewriting MS Access SQL queries as mere TSQL queries? How can these be looped over with Excel as input and output?
- Filter for values that are <0.5 and delete visible rows
- FileSystemObject to collect video file length
- Excel VBA splitting a string into a Date
- Finding a value in an Excel array
- Delete rows that are part of merged cells
- Remove URL and keep file name with extension
- Excel VBA - Nested Data in XML file