unit * price total

W

willy

Hi there

new to the wonders of Excel, sorted most probs out but any suggestions
for the following formula?
units price
2 2
2 2
tot 8

Can't get the total based on the unit * price without entering every
field and I've got 200 units and 6 price fields. Any help welcome

Thanks

Willy
 
Z

Zack Barresse

Hi there,

Assuming your ranges are A2:B3, you can use the SumProduct formula...

=SUMPRODUCT(A2:A3,B2:B3)

HTH
 
Top