Hi I am trying to create stats table to show the following:
- Number of Audits conducted prior to 2017 and how many have been closed.
- Number of Audits conducted in 2017 and how many have been closed.
I can use =COUNTIF(B11:B29,"<="&B1) to calculate the total number of audits conducted prior to 2017 but i cant seem to separate the data by type of Audit conducted and number closed.
Bookmarks