Converting a complex COUNTIFS formula into an equvalent (older) COUNTIF formula

I have an existing workbook using COUNTIFS formulas that are working without issue. I want to share this workbook with a friend who only has Excel 2003 which only supports the COUNTIF formula. I am struggling to create an equivalent query for his workbook.

Here is the formula that works in my workbook: = IF($C11="","",COUNTIFS(FT8_Log!$H:$H,"<"&K$6,FT8_Log!$H:$H,">"&J$6,FT8_Log!$R:$R,"="&$B11)) [The result is "1"]

Here is where I am at with his workbook: = IF($C11="","",(AND((COUNTIF(FT8_Log!$H:$H,"<"&K$6)-COUNTIF(FT8_Log!$H:$H,">="&J$6)),COUNTIF(FT8_Log!$R:$R,"="&$B$11)))) [The result is "TRUE"]

My formula generates a correct count based on two conditions; one is if a specific value is found within a range ($R:$R) and second is if a number value falls within a range of numbers ($H:$H).

His formula only generates a "TRUE" or "FALSE" result, not a count.

Source column $R:$R is alphanumeric.
Source column "$H:$H is numeric only.

I have spent the afternoon trying to create an equivalency and could use some guideance to a solution.

Thank you in advance!

I don't think it works with COUNTIF.

With SUM it doesn't seem to be a problem.

Please try:

Formula:

Please Login or Register  to view this content.

May be this

Formula:

Please Login or Register  to view this content.

I have looked into the history books of Excel and in Excel 2003 full column references are not allowed. Which lead to #NUM.
For that reason, the formulas from Post #2 and #3 do not work.

So try

Formula:

Please Login or Register  to view this content.

If necessary, confirm the formula with Ctrl+Shift+Enter and another Enter.

If the formula still does not work, please upload an example sheet in Excel 2003 format (that is type xls).

You are Welcome!

Nice to hear that the formula with specific ranges in Excel 2003 also works well. I didn't know this.

Thanks for the feedback and glad to have helped. .

If you haven't already, please consider adding reputation to all helpers you think they deserve.
In that case please click * Add Reputation left below their answers.