Hello
I am trying to create a formula that counts the number of 'TRUE' cells in a particular column, based on certain criteria.
Here, I have created some dummy portfolios. Each of the three individuals (Me, John, Simon) has a column that shows the number of breaches ('TRUE').
In the table on the left (yellow highlight) I am trying to calculate how many 'TRUEs' there are in the column, between a certain time period (cells C5:C6).
The idea would be that this table would update, whenever you change the dates. i.e. how many breaches in the last year, or last week, etc.
I have attached the dummy excel file
Thank you in advance!
Bookmarks