sum if colloured background
 

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

sum if colloured background
 

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

--
Kind regards,

Niek Otten

"Elleby" wrote in message
...
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