Why do you have to use CTRL-SHIFT-ENTER instead of just ENTER? What
difference does that make?

"Pete_UK" wrote:

Try this array* formula:

=SUM(IF((C$2:C$160=2)*(J$2:J$160=1)*(J$2:J$160<=7 ),1,0))

* As this is an array formula, once you have typed it in (or
subsequently edit it) you must use CTRL-SHIFT-ENTER instead of just
ENTER. If you do this correctly then Excel will wrap curly braces { }
around the formula - you must not type these yourself.

Hope this helps.

Pete