Sum Product perhaps?

[currybai]

I have the following columns:

Phone (Text)
Phone Sale (Int)
Phone Volume (Int)
Parent Phone Sale (Int)
Parent Phone Volume (Int)
Improvement (yes or no)

I want to have a summary page. The first column has all the phone list. I want to calculate the % improved, so it will either be a yes or no, so it will be the count of the Yes divided by the Yes + No per Phone.

 

[texasalynn]

is this what you mean?

Excel Workbook
	A	B
1	Phone
2	713-555-1234	25%
3	713-555-6789	0%
4	713-555-0123	0%
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B2	=SUMPRODUCT(--(Sheet2!$A$2:$A$16=Sheet1!A2),--(Sheet2!$F$2:$F$16="Yes"))/COUNTA(Sheet2!F:F)

Excel Workbook
	A	B	C	D	E	F
1	Phone (Text)	Phone Sale (Int)	Phone Volume (Int)	Parent Phone Sale (Int)	Parent Phone Volume (Int)	Improvement (yes or no)
2	713-555-1234					Yes
3	713-555-6789					No
4	713-555-0123					No
Sheet2

Excel 2003