How to do a running talley

[txwylde]

I have an excel spreadsheet. In my A column, I want to run it to count up if the C column is not null. I have tried the SUMIF but can not seem to get it to work. How can I go about preforming this function?
Thanks!

 

[HarleyQuinn]

How about something like:

=IF(SUM(C:C) > 0, SUM(C:C),"")

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[SkipVought]

Hi,

Starting in A2...
[tt]
=IF(ISBLANK(C2),A1,A1+1)
[/tt]
and copy down.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]