Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum numbers of a different colur in a row of data
How do I sum numbers in a row that has different colours. I want to sum
black colours and red colours separately |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum numbers of a different colur in a row of data
See
http://www.cpearson.com/excel/SortByColor.htm "pjenz" wrote: How do I sum numbers in a row that has different colours. I want to sum black colours and red colours separately |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum numbers of a different colur in a row of data
Sorry - wrong link
http://www.cpearson.com/excel/colors.htm "pjenz" wrote: How do I sum numbers in a row that has different colours. I want to sum black colours and red colours separately |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum numbers of a different colur in a row of data
See
http://cpearson.com/excel/colors.htm In article , pjenz wrote: How do I sum numbers in a row that has different colours. I want to sum black colours and red colours separately |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum numbers of a different colur in a row of data
You could try this alternate method which doesn't use VBA.
In 2003 you can specify the Format color to look for under EditFindOptionsFormatFormat. Select the color from the Patterns dialog and Find All. In the found dialog box the first cell will be highlighted. Hold SHIFT key and scroll down to bottom of dialog box and select last cell. The selected cells can then be summed by right-click on Status Bar and "Sum". Do for each color. Gord Dibben MS Excel MVP On Fri, 14 Sep 2007 04:14:00 -0700, pjenz wrote: How do I sum numbers in a row that has different colours. I want to sum black colours and red colours separately |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting numbers from data | New Users to Excel | |||
Numbers Into Data | Excel Discussion (Misc queries) | |||
Numbers Into Data | Excel Worksheet Functions | |||
No colur in normal view but is in print preview | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions |