Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells with color and multiply
Have a schedule with bookings blocked by colour
each block is 4hrs unless it is 6hrs (indicated with text 1800hrs) have managed to get a total (say 8) of how many of each coloured block, but want to have a final column that would tally hrs. i.e. if no 1800 then then total (8) is multiplied by 4 = 32, but it could be (4*4) +(4*6)=40 Any chance? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells with color and multiply
Maybe this will help http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tmirelle" wrote in message ... Have a schedule with bookings blocked by colour each block is 4hrs unless it is 6hrs (indicated with text 1800hrs) have managed to get a total (say 8) of how many of each coloured block, but want to have a final column that would tally hrs. i.e. if no 1800 then then total (8) is multiplied by 4 = 32, but it could be (4*4) +(4*6)=40 Any chance? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells with color and multiply
tried a couple of the =sumproduct functions... not being well versed in these
I'm not sure how to manipulate the function to get what I am after... Any thoughts? "Bob Phillips" wrote: Maybe this will help http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tmirelle" wrote in message ... Have a schedule with bookings blocked by colour each block is 4hrs unless it is 6hrs (indicated with text 1800hrs) have managed to get a total (say 8) of how many of each coloured block, but want to have a final column that would tally hrs. i.e. if no 1800 then then total (8) is multiplied by 4 = 32, but it could be (4*4) +(4*6)=40 Any chance? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum cells with color and multiply
Give of some more details of the problem, what you have tried, what you get
etc. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tmirelle" wrote in message ... tried a couple of the =sumproduct functions... not being well versed in these I'm not sure how to manipulate the function to get what I am after... Any thoughts? "Bob Phillips" wrote: Maybe this will help http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tmirelle" wrote in message ... Have a schedule with bookings blocked by colour each block is 4hrs unless it is 6hrs (indicated with text 1800hrs) have managed to get a total (say 8) of how many of each coloured block, but want to have a final column that would tally hrs. i.e. if no 1800 then then total (8) is multiplied by 4 = 32, but it could be (4*4) +(4*6)=40 Any chance? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|