Anyone has any idea on how to solve pic related using functions only?
>>59981053
Use if, min, max, average
>>59981144
Im gonna need instructions with more details.
I uploaded document here uploadfiles(dot)io(slash)s9353
>>59981248
I've googled it for you faggot, check this for the instructions: https://exceljet.net/formula/max-if-criteria-match
=sudo apt get gentoo
This isn't a homework board. Do your own research first before posting here
Check the database commands. They could easily do this.
>>59981291
Doesn't work with multiple criteria.
Utkan-senpai notice me ~
>>59981053
Use the SUMIFS function and do your homework>>59981053
>>59981496
There is no use for sumifs here. Only averageif, maxif and sumif. The later 2 are not available on excel 07
>>59981053
If you were not a faggot and used SQL instead of excelselect [age group], min(age), max(age), avg(age)
from table
group by [age group]
>>59981053
It's either =vlookup or =index
cant remember which one's which
or you could just use the cheat way and have excel sort it by "age group" than individually call =min, =max, =average
Or do what our friend: >>59981144 said if you prefer