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

Hi,

how about

Formula:

Please Login or Register  to view this content.

Thanks for the quick reply!

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.

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.

you should specify "between 3 and 5 condition separately, i.e.

Formula:

Please Login or Register  to view this content.

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.