Not sure what you mean by:

but I don't want to type it out... just drag and fill?

sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)

This formula does the same thing as the one above:

=SUMPRODUCT(A1:C1+A2:C2,A3:C3)

--
Biff
Microsoft Excel MVP


"Melissa" wrote in message
...
I have 3 columns and 3 rows:
A1 B1 C1
A2 B2 C2
A3 B3 C3

In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and
C
Is there a formula which allows me to sum up row 4 without first obtaining
the values by columns A, B and C? i.e. something like:
sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it
out...
just drag and fill?