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.
Bookmarks