Hi there
I would like to count a list value which have a range value for example 60-80,
The idea is > = countif (B1:B15,"80-60").. So how i do the right command,
try to used this;
= SUM(INDIRECT("B"&MATCH(0.3,B$1:B$15,0)&":B"&MATCH (0.4,B$1:B$15,0)))
but returning with #NA.
Please correct me if I'm wrong or better idea
br, mohsin
Bookmarks