# Trying to count cells greater than # in one column if another column meets criteria

1. ## Trying to count cells greater than # in one column if another column meets criteria

Hello there,

I am trying to count the number of cells in Column J21:J220 if the number is great than 6 and if the column C21:C220 = "Y" in the same row.

What function should I use? I tried COUNT without success and DCOUNT requires me to have a table off to the side with criteria that I want to avoid if possible.

Can anyone help?

I know this formula is way off but here is my attempt:
``Please Login or Register  to view this content.``
Thanks,
Lorne

2. ## Re: Trying to count cells greater than # in one column if another column meets criteria

Try this:

``Please Login or Register  to view this content.``

3. ## Re: Trying to count cells greater than # in one column if another column meets criteria

Hi,

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Trying to count cells greater than # in one column if another column meets criteria

Ok so I put that formula in and it adding the number in the J column. I don't want to add the actual number, I just want to count how many cells meet the criteria.

So using your formula I get 48 (one cell is 29, the other is 19. 19+29=48). I want that formula to come out to equal 2. Because 2 cells in Column J are greater than 6.

Does that make sense?

Thanks so much for the help,
Lorne

---------- Post added at 04:42 PM ---------- Previous post was at 04:40 PM ----------

Wakeupcall,

I tried your formula and got a #VALUE!??

I tried to replace your first comma with '=' and it wasn't fixing it.

``Please Login or Register  to view this content.``

5. ## Re: Trying to count cells greater than # in one column if another column meets criteria

Hi Lorne,

Please recheck the formula, it should only give you a count of the cells meeting the criteria.

6. ## Re: Trying to count cells greater than # in one column if another column meets criteria

I got it working:

``Please Login or Register  to view this content.``
Thanks for the help, you guys got me on the right path.

---------- Post added at 04:51 PM ---------- Previous post was at 04:47 PM ----------

Ok well I got one working. Now I can't seem to get this to work for the same columns if the numbers are less than 3 or between 3-5?

``Please Login or Register  to view this content.``
``Please Login or Register  to view this content.``

7. ## Re: Trying to count cells greater than # in one column if another column meets criteria

you should specify "between 3 and 5 condition separately, i.e.
Formula:
`Please Login or Register  to view this content.`

8. ## Re: Trying to count cells greater than # in one column if another column meets criteria

Perfect!

Thanks Wakupcall.

Here's the final three equations:
``Please Login or Register  to view this content.``
Finds the outstanding RFIs for the number of days they are open. 6Days and older, 3-5 days old, 0-2 days old.

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