Formulas
 

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?

Formulas
 

Have a look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gemgirl" wrote in message
...
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?

Formulas
 

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
--
Max
Singapore
---
"Gemgirl" wrote:
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?