Formulas

  • Thread starter Thread starter Gemgirl
  • Start date Start date
G

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?
 
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
 
Back
Top