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?

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?

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?

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?