These are my columns, I have only included the ones that I'm using.
B G L AI
name address Postcode [Formula] either "1" or "0"
=IF((OR(G10="", L10="")), "0","1")
I have about 14,000 rows and about 500 different names in column B, what I'm looking to do is find the count of "1"s in column AI with a specific name from Column B.
I don't what formula to use or who to contstruct it? Can someone help?
Does that make sense?
Bookmarks