Subtotal and Grand Total Functions

[chuckden]

Hello all. For the life of me, I can't get my sum functions to work
with text entries. FTR, I am using Excel 2003. The purpose lays in
this example... I have a column with three different alpha-codes that
have been designated like this:

A denotes blue textbooks
B denotes brown textbooks
C denotes red textbooks


In this column, there are 45 rows with either an A, B or C
classification. Is it possible to add a function/formula where I can
automatically calculate a subtotal of each, then a grand-total of all
classifications together?


I know this is a weird request, but I have been out of the function
loop far too long, and I am certainly not a coder, by any means.


Thanks in advance for your great help!


Chris

 

[RobN]

One way....

Assuming your data starts at A2, enter this in a cell.
=SUMPRODUCT(--($A$2:$A$45="A"))
Do the same for alpha-codes B and C, but change the formula accordingly.

Then simply sum those 3 cells to give a total. ie =sum(B11), if you've
placed those formulas in B1, C1 and D1

Rob

 

[Dave Peterson]

=countif(a2:a999,"A")
will count the number of cells that contain A.

=counta(a2:a999)
will count the number of entries in that range (values or formulas).