software

hi
we have a sheet were we had load places on top and delevery places in the
left collum. the number of colli and killos is put ind the grid.
We then put it on different trucks - we marked it with differet background
colours.

Is there a way we can sum the total weight for each truck ???

Excampel: A B C D
1 London Dover York
2 Kbh 10 12 23
3 Esbj 11 3 8

truck 1 (21 ton from Kbh Esbj to London - 10 11t)
truck 2 (20 ton from Kbh Esbj to Dover York with 8 12)
truck 3 (26 ton from Kbh Esbjerg to Dover York with 3 23t)

Thanks

www.xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten

quot;Ellebyquot; gt; wrote in message
...
gt; hi
gt; we have a sheet were we had load places on top and delevery places in the
gt; left collum. the number of colli and killos is put ind the grid.
gt; We then put it on different trucks - we marked it with differet background
gt; colours.
gt;
gt; Is there a way we can sum the total weight for each truck ???
gt;
gt; Excampel: A B C D
gt; 1 London Dover York
gt; 2 Kbh 10 12 23
gt; 3 Esbj 11 3 8
gt;
gt; truck 1 (21 ton from Kbh Esbj to London - 10 11t)
gt; truck 2 (20 ton from Kbh Esbj to Dover York with 8 12)
gt; truck 3 (26 ton from Kbh Esbjerg to Dover York with 3 23t)
gt;
gt; Thanks
gt;
gt;
gt;