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?
See screenshot for reference. (Would have attached excel file, but it wouldn't let me upload- think it might be too large).
Thanks
Bookmarks