| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing the last 7 non-blank entries in a row of data
I have a continually growing row of data that I want to sum automatically.
An example is: I want to store the sum in cell A1, data is currently in cell B1, C1, E1, F1, and H1. B1=2, C1=3, E1=1, F1=4, H1=2. I want the result in A1 to = 12. The next day I add data to cells I1, J1, K1, and M1, where I1=2, J1=3, K1=2, M1=5. After adding the new data, I want the result in A1 = E1+F1+H1+I1+J1+K1+M1 = 19. I found the following equation in one of the discussion threads for this scenario, but I noticed it doesn't add up correctly. Is there a way to do do this? Any help would be appreciated! Found equation: =SUM(OFFSET(B1,,COUNTA(B1:CO1),,-(MIN(COUNTA(B1:CO1),7)))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Threaded Mode
