I require a formula to count the first 20 entries which are reporting as ‘Ongoing’ and which have a scoring of 21 and above.
I assumed that it would be a simple COUNTIFS where I created the following:
=COUNTIFS(‘Portfolio Register’!BG:BG,”>=21″,’Portfolio Register’!S:S,”Ongoing” )
However the above formula returns a full count of everything with a scoring of 21 or above and which is marked ‘ongoing’. I only want the first 20 which meets this criteria.
I would be grateful for any help!!