Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula to use?
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. |