Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |