So I have been working on this problem for a couple of hours and just can't get this to work.

I have three separate Columns in a Sheet called APFTData1st

I am trying to determine if data located in APFTData1st!H2:H59, APFTData1st!J2:J59, APFTData1st!L2:L59 is greater than 50, but less than 60.

If all three columns are greater than 50 but less than 60 it will count the number of people/rows that meet the criteria instead of counting individual cells that meet all three criteria in cell Overview!E28.

I have tried using COUNTIFS(), and SUMPRODUCT() as an array and just can't nail this down any help would be greatly appreciated.

Thanks,
Pete