K
Karen
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.
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.