Notifications
Clear all
Excel
3
Posts
2
Users
0
Reactions
193
Views
Topic starter
Hi,
This is my old formula =COUNTIF(B24:AF24,"P")+COUNTIF(B24:AF24,"P / PP")
Is there a better formula to use with 365?
Posted : 15/01/2021 9:08 am
Hi Steve,
Welcome to our forum!
You could use the FILTER function to extract the matching cells and then count them, like this:
=COUNTA(FILTER(B24:AF24,(B24:AF24="P")+(B24:AF24="P / PP")))
Not sure that it's any more efficient though. You'd have to test it.
Mynda
Posted : 16/01/2021 12:00 am
Topic starter
Thanks Mynda,
Posted : 16/01/2021 4:41 am
