=SUMPRODUCT(L2:L186,q2:q186)
--
Don Guillett
SalesAid Software

"Mel" wrote in message
...
I need to multiply the total number of items in my column Q (e.g. POD's
delivered) by the different tonnages in column L to get a total tonnage
result? There are 186 rows. Any ideas please?