how do i set up a formula to add a '1' to a total each time a spe.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to do a running total each time a specified text string appears. The
specified text string will be in Column A and there will be other text
strings in this column. I want to do a running total for each text string.
Any Suggestions?
 
Sounds as though you should look at COUNTIF

Maybe use Filter | Advanced Filter to get a list of unique string first

Regards

Trevor
 
I'm going to use R1C1 notation rather than the idiotic A1 notation.

If you have text, numbers and running total in columns 1, 2, & 3
respectively then do this:

in R1C3: =IF(RC1="TextToMatch",RC2,0)
in R2C3:R*C3: =IF(RC1="TextToMatch",RC2,0)+R[-1]C

How is that?

James.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to add numbers in a text string 5
Getting Text data using the Data - Subtotal feature 1
Text to columns 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
turning text into a calculated result: 3
Nesting a sumproduct formula within a sumif formula. 2
Cut the last 20 characters out of a text string 4
Count number times text appears in string 1

Back
Top