Expanding a Countifs statement

[Icehockey44]

Hi All,

I am trying to expand on a Countifs statement!!

I am using the following formula:

=COUNTIFS($J$2:$J$5009,1,$L$2:$L$5009,"<=359")

Which looks at column J and counts all the 1's, then looks at column L and counts all the numbers that are less than or equal to 359. which works fine.

But now in Column L, I need it to bring back all the instances where the numbers are between 360 and 719, still looking at column J for the 1's.

Is this possible?

cheers

Donna

[Andrew-R]

Something like this should do what you're looking for:

=COUNTIFS($J$2:$J$5009,1,$L$2:$L$5009,">=360",$L$2:$L$5009,"<=719")