I am trying to work out how to do the following. I have two Excel sheets: one for data and one for stats. The data sheet stores the number of units bought by each named customer – on multiple occasions. The stats sheet has a single row for each customer name – but should show in a separate column how many times the units bought exceeded a certain threshold.

For example:

And:

I am adept at VBA, and could produce a custom function to do this. However, I want to find a way to do this within non-VBA formulæ: i.e standard Excel nested formulas. This is because it is for a corporate spreadsheet, where the management wants to keep things as simple as possible – in xlsx format.

I’m sure it could involve a COUNTIFS function – but can’t quite get my head around which combination of native functions to use. Any assistance gratefully received.