ExcelBanter - Counting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting (https://www.excelbanter.com/excel-discussion-misc-queries/112166-counting.html)

Mel

Counting

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?

Don Guillett

Counting

=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?

All times are GMT +1. The time now is 05:55 AM.