Thanks for the reply! So close now. I am now returning a 0. Everything looks good and I am wondering if the database that generates the data is giving me some kind of formatting that is causing problems. I verified that the numbers are numbers and not text. Think of anything else to double check?
Thanks again!
Current line returning 0 Should be returning 5 or more.
=SUMPRODUCT((('Entire Sites - Offices - Staff'!B5:B99="Northern Oklahoma District")+('Entire Sites - Offices - Staff'!B5:B99="Rocky Mountain District")),--('Entire Sites - Offices - Staff'!G5:G99>0),--('Entire Sites - Offices - Staff'!G5:G99<60))
Bookmarks