Good morning to all,
I am trying to prepare an excell spread sheet for calculating % progress.
This Question is MS Excell related.
From a group of Columns [ i.e c5: L5]
to capture data from the cells c5 to L5 where ever the colour of the cell is green. and to return the cummulative value in the desired cell.
10,10,5,25,50,
if these are the values in the coloumn and only ist 2 cells are coloured green.
i am expecting the value to be returned is sum of the green coloured cells . i,e [ 10 + 10 } = 20
if the ist 3 cells are green . Then [ 10+10+5]=25
if all are green then [ 10+10+5+25+50] = 100.
Can any body help please
What function is to be used to call the colour of the cell?
If the Colour matches to the reqd Colour , how to call for the value?
And then Sum up the Values?
Regards
Shiv Rao
I am trying to prepare an excell spread sheet for calculating % progress.
This Question is MS Excell related.
From a group of Columns [ i.e c5: L5]
to capture data from the cells c5 to L5 where ever the colour of the cell is green. and to return the cummulative value in the desired cell.
10,10,5,25,50,
if these are the values in the coloumn and only ist 2 cells are coloured green.
i am expecting the value to be returned is sum of the green coloured cells . i,e [ 10 + 10 } = 20
if the ist 3 cells are green . Then [ 10+10+5]=25
if all are green then [ 10+10+5+25+50] = 100.
Can any body help please
What function is to be used to call the colour of the cell?
If the Colour matches to the reqd Colour , how to call for the value?
And then Sum up the Values?
Regards
Shiv Rao