Thanks Patele. I've just spoken with the person I'm doing this formula
for....and he's given me the totally wrong information! ARGH!!! thanks for
your help anyway :)

"patele" wrote:


Mel,

You're on the right track. Try this

=SUM($B$3:$D$3)*E3*F3


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=561978