COUNTIF to 20 entries

Hi,

 

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!!

By: imzkhan

Leave a Reply

Your email address will not be published. Required fields are marked *