conditional count
 

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.

What determines that it is on-going?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karen" wrote in message
...
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.