krispartsbadger
New Member
- Joined
- May 13, 2022
- Messages
- 23
- Office Version
- 365
I continually add values to a single row. What is a formula that shows the last 3 cells that have values. So If i have values in A1,A2, A3 A4, it would be the sum of A2-A4. And once I enter a value into A5, the formula will grab the sum of A3-A5 I want to see this rather than always highlighted the last 3. Thanks.