poor_cookie
New Member
- Joined
- Dec 16, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
I would like to count the sum of all the ones from A11 to A17. They are obtained by applying a formula on (A2:B8) and discussed in #post-5605524
So, from A11 to A17, the sum will be 3. However, the list of IDs is dynamic (there could be 10 IDs, or 100 IDs). I think the SUM formula can help, but instead of displaying 100 rows of zeroes and ones before summing up, is there a way that I can find the sum of all the ones, regardless of the size of the data, on a single cell?
So, from A11 to A17, the sum will be 3. However, the list of IDs is dynamic (there could be 10 IDs, or 100 IDs). I think the SUM formula can help, but instead of displaying 100 rows of zeroes and ones before summing up, is there a way that I can find the sum of all the ones, regardless of the size of the data, on a single cell?