Thread: Need formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Need formula

The feature of Data Subtotals ....follow the menus.........will produce a
nice "report" which may be of interest.........

Vaya con Dios,
Chuck, CABGx3



"Steve" wrote:

I have a spreadsheet that has 2 columns, column A are values that repeat such
a A, B,C. Column 2 are numeric values. I want to add all A's, all B's, all
C's like such. How do I accomplish this? I am completely new to Excel. Thanks
for all help in advance.

Column A Column B Totals
A 1 A 2
B 1 B 2
C 1 C 2
A 1
B 1
C 1