Hi all,
=COUNTIFS(B17:BN23,"H",B24:AF28,"H",AJ24:AU24,"H")
For some reason I get the #value error when doing the above formula and cannot think why?
Any ideas? Sorry I could not post a test spreadsheet as I am posting this from my mobile phone.
Thanks in advance
Bookmarks