Calculating Sales Close Rate

[Sarida]

I want to set up an Excel spread sheet where I can put my total number of sales appointments for the month and the percentage of those I closed. I've done this before, but for the life of me I can't remember the formula I used & I know it's a very simple one!
I'm using Office 2007.

[Tony Valko]

Something like this...

Data Range

	A	B	C	D
1	App #	Status	------	% Closed
2	App1	Closed		60%
3	App2
4	App3
5	App4	Closed
6	App5	Closed
7	App6	Closed
8	App7	Closed
9	App8
10	App9	Closed
11	App10

=COUNTIF(B2:B11,"Closed")/COUNTA(A2:A11)