spinitback
New Member
- Joined
- Aug 10, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi all. I'm using Excel for M365
I have a column of numbers
In this column I have 17 occurrences of a number greater than equal to 1500.
For the first 12 occurrences of a value greater than equal to 1500, I don't want to do anything.
For all other occurrences in that column (in the above example, 5 occurrences) with a value greater than equal to 1,500, I want to automatically calculate the sum of those occurrences.
ie for this column: 1500+3000+1500+3000+1500 = 10500
I'm hoping the forum can help, thanks!
-Spin
I have a column of numbers
In this column I have 17 occurrences of a number greater than equal to 1500.
For the first 12 occurrences of a value greater than equal to 1500, I don't want to do anything.
For all other occurrences in that column (in the above example, 5 occurrences) with a value greater than equal to 1,500, I want to automatically calculate the sum of those occurrences.
ie for this column: 1500+3000+1500+3000+1500 = 10500
I'm hoping the forum can help, thanks!
-Spin