you could use something like
which would give average of ages beween 20-29![]()
=(SUMIF(B1:B20,">=20")-SUMIF(B1:B20,">29"))/(COUNTIF(B1:B20,">=20")-COUNTIF(B1:B20,">29"))
you could use something like
which would give average of ages beween 20-29![]()
=(SUMIF(B1:B20,">=20")-SUMIF(B1:B20,">29"))/(COUNTIF(B1:B20,">=20")-COUNTIF(B1:B20,">29"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks