yogi_Counting Entries In A Filtered Table That Meet Specified Criteria Using SUBTOTAL Function

Google Spreadsheet   Post  #2547

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-18-2018

question by: Perk1961:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/bC0Vt7zur5c;context-place=mydiscussions

Countif greater than with hidden rows

I am trying to count the how many times the number 4500 or greater appears in 5 separate columns. I can do this in excel using Sumproduct with subtotal and offset in the string,  but the same formula does not translate to Google Sheets. I have searched tirelessly online but can't find a solution. Any help would be appreciated.

See sample sheet file below.

https://docs.google.com/spreadsheets/d/1vKNUsZkzeyKBj--Kf8DBG00aYO2PiS4xl0KYCWDoNW0/edit?usp=sharing

Note: The formula in cell B4 works in excel, which is =SUMPRODUCT((B7:F19>=4500)*(SUBTOTAL(103,OFFSET(B7,ROW(B7:F19)-MIN(ROW(B7:F19)),0))))

Thanks in advance.