Formulas

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?
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Multiple "IF's" or maybe "COUNTIF's"??? 7
formula with yes and no 6
Count yes against name 1
division with blank cells 5
Question regarding the making of a selection in a certain column a 1
Characters in logical calculations 1
Excel Count from last specific text 3
Separating data in a column 2

Top