excel+and+powerpoint+courses+uk - Count Multiple Criteria on a Dynamic Range | Excel forum

I need to count the amount of lines where column A equals "Criteria 1" and column B equals "Criteria 2".

The Range will on continually change/increase over time.

This formula will be used on a summary page, created by a macro. I want the macro to enter the formula & not the just the value, as I would like the user to be able to see how the formula works.

I also do not want to add a another column testing the source data, as the source data is live information used by members of staff.

I would also like to use this formula in other circumstances where all I have to do is specify the criteria, source data and the columns to test.