inferno657
New Member
- Joined
- Aug 11, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hi,
Essentially I need to count the total number of rows that have a claim count greater than zero, for each year. 2018, 2019 and 2020. So essentially 'count IF year ends in 2018 AND claim count greater than zero', repeating this for 2019 and 2020 etc.
How can I go about doing this?
Essentially I need to count the total number of rows that have a claim count greater than zero, for each year. 2018, 2019 and 2020. So essentially 'count IF year ends in 2018 AND claim count greater than zero', repeating this for 2019 and 2020 etc.
How can I go about doing this?