Hi Brickman,
Part 1 of your question
Try the formula
=IF(ISERROR(SUMIF($L$7:$L$22,"=1",$D$7:$D$22)/SUMIF($L$7:$L$22,"=1",$C$7:$C$22)),"",SUMIF($L$7:$ L$22,"=1",$D$7:$D$22)/SUMIF($L$7:$L$22,"=1",$C$7:$C$22)).

Part 2 of your question
Try the formula =LEFT(A1,LEN(A1)-3)&"900"

Can anyone answer my "Get external data" question?

Regards Mick Barry
If you need a bricklayer then get your chickens to eat clay.


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=507017