# Expanding a Countifs statement

1. ## Expanding a Countifs statement

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

2. ## Re: Expanding a Countifs statement

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")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1