Running Count

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

Guest

I have a spreadsheet with two columns: Amount and RunCt. I would like to get
a function to show a running count of unique dollar amount that shows up in
the RunCt column. Any thoughts on how to do this?

Amount RunCt
$100 1
$200 1
$100 2
$50 1
$100 3
 
briank -
Assume your 'Amount' values begin in A1 and you want your running count to
be in column B, place this formula in B1 and drag down:

=COUNTIF($A$1:A1,A1)
 
Try this in B2:

=COUNTIF($A$2:A2,A2)

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Dave,
Thanks a bunch - your formula worked gr8!

David Billigmeier said:
briank -
Assume your 'Amount' values begin in A1 and you want your running count to
be in column B, place this formula in B1 and drag down:

=COUNTIF($A$1:A1,A1)
Click to expand...
 
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

How to export table from outlook into ms access table? 0
Access Running Balance in Access 1
How do I count the number of entries of specifc criteria is met 2
Find Sum of Values corresponding to each value type 1
Pivot Table GETPIVOTDATA 2
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Count and Sum functions with 2 criterias 20
SUMIFS, one criteria range, multiple criteria 3

Back
Top