Counting Formula Conditionally
There is an Excel file that teaches how to perform the Counting Formula Conditionally operation.
Excel Counting Formula Conditionally
This workbook demonstrates counting formula conditionally using VBA macros on a 3-row data layout.
Hope it is useful.