COUNTIFS() Help

[GO4GONE]

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

[FDibbins]

Hi and welcome to the forum

It might to offer suggestions if you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[GO4GONE]

upload.xlsx

On the overview workbook, I am looking for cell E27 to ultimately contain two numbers I receive from the formula, the end state would be, persons who have Passed (p) at 50% and the number of persons who have failed at 50%, in the format P/F.

This data needs to be pulled from APFTData1st workbook columns H2 - H59, J2 - J59, L2 - L59.

The criteria is all three persons must be greater than 50% but less than 60% in order to be counted, if they do not fall in between that range they are skipped over.

I have tried using COUNTIFS and SUMPRODUCT, I can get SUMPRODUCT to only count one column not verify all three.

I was trying to modify this =SUMPRODUCT((APFTData1st!H2:H59>=50)*(APFTData1st!H2:H59<60)) but was not getting anywhere.

Thanks again,
Pete