what if I told you you could find the
some average or count of cell range
without using a single formula it's true
and it's very easy to do in fact you
don't really have to do anything because
Excel runs these calculations
automatically whenever you select a cell
range and it displays the results here
near the lower right corner for example
I have some basketball stats and I can
select any column of data to quickly see
the total points scored in a specific
game
I can also select a specific players row
to see the total points scored by that
player or their average points per game
when selecting text values it won't show
a sum or average but it still shows the
count which we could use to quickly see
how many players are on the team
now it's still a good idea to create
formulas for calculations that you'll
use over and over but if you just need
some quick info about your spreadsheet
this is a fast and easy feature to use
Goodwill Community Foundation creating
opportunities for a better life