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

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

--
Kind regards,

Niek Otten

"Elleby" <Elleby@discussions.microsoft.com> wrote in message
news:3D7CA2A9-58B0-4773-9D61-E76EEABDE4D9@microsoft.com...
> 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
>
>
>