Formulas

[Gemgirl]

how can I sort the data in a column of cells and create a total in another
cell? in my document, there is a column with 2 possible answers, we'll say
yes or no, as an example. How can I sort that data and then total the yes's
and no's in another area on my spreadsheet?

 

[Don Guillett]

Have a look in the help index for SUMIF

 

[Max]

Try also the joys of a pivot for quick analysis. In Layout, place the col
header (for the Yes/No/etc) into the ROW area and into the DATA area (set to
Count), click to Finish up. Check out the results, the pivot returns the
uniques listing of all the responses (ie Yes/No/etc) and their corresponding
counts. Inspiring? hit the YES below