#### andrewpennell

##### New Member

- Joined
- Mar 4, 2016

- Messages
- 5

Thanks ahead of time for reading my post.

I'm trying to extract data from the results of a VLOOKUP.

When I use

=countif(M3:M291,"<=60")

on values I copied from the VLOOKUP and pasted as values onto the same sheet, I get the correct answer.

However, when I try the very same formula but reference the range on the VLOOKUP, I get a much larger number.

This leads me to believe that the latter formula is counting hidden values.

Thus, my question is: How can I run a COUNT, AVERAGE, etc on a VLOOKUP table that a) excludes hidden values AND b) returns values based on a simple comparison (e.g., ">=5").

I'm aware that the SUBTOTAL function allows me to COUNT, AVERAGE, etc a range and exclude hidden values, however, I need to return values based on a simple comparison check (">=5", etc)

I'd really appreciate it if someone could also explain their solution by each attribute in whatever function they use.

Thanks for all the help!