I have a range of cells (K10:K77) that consist of a drop down list of 4 different choices (MIW, Non-MIW, SIP, Self-Employment) and I have another range of cells (L10:L77) that is either ({Blank} or 'y'). When I use the Countif formula I am able to correctly count the number of instance of each of the choices in range K10:K77. But when I try to add the "y" indicator from range L10:L77 using Countifs then I get an error message. The formula I am trying is -- =COUNTIFs(K10:K77, "MIW"; L10:L77 , "y"). When I do this the K10:K77 turns blue.
I want to be able to count the number of MIW, Non-MIW, SIP, Self-Employment that have the "y" indicator from the other range (L10:L77).
Any assistance would be greatly appreciated.
Bookmarks