unit * price total

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

Hi there,

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

=SUMPRODUCT(A2:A3,B2:B3)

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"willy" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> willy
> ------------------------------------------------------------------------
> willy's Profile:
> http://www.excelforum.com/member.php...o&userid=32901
> View this thread: http://www.excelforum.com/showthread...hreadid=527220
>

thanks Zack

I'll have a crack at it.