Hi,
I am trying to do a conditional count on a chart to determine if a project
is ongoing. I have figured out how to do it row by row, but am wondering if
there is a formula I can use at the bottom of the column instead of adding an
extra column and adding it up. This is what I want the results to look like
in the finished spreadsheet.

1999 2000 2001
Project 1 $500 $500
Project 2 $100
Project 3 $100 $100

Ongoing 0 1 1

Thank you for any help you can give me.