Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table reports-summary
I want to summarize data in one column into 3 different catagories. How can i
do this? example: A N A A A A D D what are the total number of A's, total number of N's and Total number of D's? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table reports-summary
Header1
A N A A A A D D Use header as both a row field and a data field. Produced: Count of Header1 Header1 Total A 5 D 2 N 1 Grand Total 8 for me. -- regards, Tom Ogilvy "angie" wrote: I want to summarize data in one column into 3 different catagories. How can i do this? example: A N A A A A D D what are the total number of A's, total number of N's and Total number of D's? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Reports | Excel Discussion (Misc queries) | |||
how to print reports from pivot table | Excel Discussion (Misc queries) | |||
Pivot table reports cannot overlap another pivot table | Excel Programming | |||
Problem with Pivot table reports | Excel Programming | |||
MS Excel - How can I summarize a table? Will Pivot Table Reports do this for me? | Excel Programming |