sum if colloured background

[Guest]

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

 

[Niek Otten]

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