Adding using conditional cell

A

arthursdomain

I have a two cells one with a 'number' value and another with a 'text'
value
i would like to have the number cell add up based on the text value.
ie.

1 2 3 4
A 2 S

B 2 S

C 3 SM

So then, because row A and B's text is S they will be added together to
= 4.
is there a way where i can make a formula or a table to calculate this?

Z
 
D

Dave Peterson

First, sort your data by that second column, so all the S's are grouped
together.

Then add a single header row at the top of your data.

Select that range (all the rows and all the columns you need) and do:
Data|subtotals

You'll be able to choose which field to use as the "control" and what to do with
each of the other fields (Sum). Remember to check the fields you want
subtotaled.

After you finish that data|subtotal, you can use the outlining symbols to the
left to hide/show the details--try clicking on those numbers at the top of those
symbols.
 
Top