andrewpennell
New Member
- Joined
- Mar 4, 2016
- Messages
- 5
Hey Everyone.
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!
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!