| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
| Gridlines into excel spreadsheet after changing background color | Excel Worksheet Functions | |||
| Form-filling application with Excel (background image)? | Excel Discussion (Misc queries) | |||
| Background Picture OR text over a picture | Excel Discussion (Misc queries) | |||
| Photo for background takes a lot of space (MB) | Setting up and Configuration of Excel | |||
Linear Mode
