Notifications
Clear all
Topic starter
HELP! This has been driving me mad!
Attached sheet - Using formulas, please provide how many of the MPANs starting with '13' are on supply at present?
So, where column K is N/A, count how many in Column I start with "13".
I have tried numerous different approaches and failed massively!
=COUNT(IF(LEFT(I2:I70,2)="13",1,"")) returns the number 17...
Probably over thinking the issue but please feel free to do the other test questions too 
Posted : 04/03/2022 10:38 am
Hi Ben,
Welcome to our forum. You can use the FILTER function for this like so:
=COUNT(FILTER(I2:I70,(LEFT(I2:I70,2)="13")*(K2:K70="N/A")))
Mynda
Posted : 04/03/2022 8:17 pm
Ben Lee reacted
Topic starter
Awesome! Thanks Mynda
Posted : 05/03/2022 10:39 am
