Okay I'm stumped. I have been using 2 deep countifs, and a new project requires 3 deep countifs. No problem right... wrong. I have tried several different methods, and each one will work fine 2 deep, but at 3 deep its stops working. I have tried using Named addresses, and specific address.
=COUNTIFS(Listing!B8:B34,"Jan",Listing!E8:E34,"LODD",Listing!H8:H34,"Fire")
=COUNTIFS(letter_Month,'Stat Sheet'!A10,Injury_or_LODD,"LODD",Service,"Fire")
I am including the file. I am hoping that some of you are not starting the Christmas travel season as of yet.
Thanks
Kent
Bookmarks