COUNTIF to 20 entries



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 *