## Count if row meets internal criteria in Excel

This tutorial shows how to Count if row meets internal criteria in Excel using the example below; To count rows in a table that meet internal, calculated criteria, without using a helper column, you can use the SUMPRODUCT function. Formula =SUMPRODUCT(–(logical_expression)) Explanation Context Imagine you have a table of sales figures for several products. You …