xle

76

=COUNTIFS(joined,">="&start,joined,"<="&end)
age, ">="&LEFT(G8,FIND("-",G8)-1) // low
=COUNTIFS(joined,">="&start,joined,"<="&end,
age,">="&LEFT(G8,FIND("-",G8)-1),
age,"<="&RIGHT(G8,LEN(G8)-FIND("-",G8)))
joined,"<="&end // greater than or equal to start
age,"<="&RIGHT(G8,LEN(G8)-FIND("-",G8)) // high
joined,">="&start // greater than or equal to start
age,">=0"

Comments

Submit
0 Comments