you could just do, in D1

=a1*c1

and then copy the formula down for all your rows, then in a blank cell
to the right of your formula results (say if you've got the results in
column D), just put =SUM(D1:D45) & substitue the last number there
(D45) with however many rows you're dealing with.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=395327