What formula to use?
I have just found that by double clicking in the "Total" cell, the value
actually changes but is this correct.
Should I have to double click this cell after each/any change?
Thanks
"hollies" wrote:
Hello
I can't seem to find if this can actually be done but, using Excel 2003, I
have a worksheet with several blocks containing cells numbered from 1 to 100.
From these blocks, I want to be able to count each cell as a value of 1 if I
change the background colour to red (or any other colour) then multiply that
value by a number, say 5.
eg If I select the first 25 cells and fill them red, I want my "total" Cell
to show the sum of 25 * 1 * 5 giving me 125.
Hope this is understandable!
Thanks for any help.
|