OK.. As my title says I want to be able to list up projects with different status. For this example lets use Delivered and Ongoing.
And I need Excel to count how many Delivered and Ongoing projects there are and return the number in another sheet to be used as data for a chart.
I've attached a sample workbook. So.. Count the status in Sheet2 and display it in Sheet1.
Can anyone help?
Bookmarks