"JE McGimpsey" wrote in message
...
One way:

=SUMPRODUCT(A1:A100,B1:B100,C1:C100)

What? And use SUMPRODUCT() the way that Microsoft intended it to be used?
How unusual! <g

--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
One way:

=SUMPRODUCT(A1:A100,B1:B100,C1:C100)

Note that all the column lengths must be the same.

In article ,
ntobias wrote:

I am new to excel and to multiply three colums together then add them
together for a final answer in a box