| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Add only the BOLDED numbers in a column.
I have a column of numbers and some of them are in boldface. How can I add
only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
How did they become bolded?
-- Don Guillett SalesAid Software "Rich D" wrote in message ... I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
I made them bolded...they are like subtotals...I didn't want to make a
separate column of them. Can it be done? -- Rich D Armstrong Custom Homes Redmond "Don Guillett" wrote: How did they become bolded? -- Don Guillett SalesAid Software "Rich D" wrote in message ... I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
Also, I could make them a certain color or whatever...Can I add only those
numbers in a column with certain characteristics? -- Rich D Armstrong Custom Homes Redmond "Don Guillett" wrote: How did they become bolded? -- Don Guillett SalesAid Software "Rich D" wrote in message ... I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
Look in the help index for SUMIF. If many conditions you may need a
sumproduct formula which is not well documented. =sumif(b2:b22,4) -- Don Guillett SalesAid Software "Rich D" wrote in message ... Also, I could make them a certain color or whatever...Can I add only those numbers in a column with certain characteristics? -- Rich D Armstrong Custom Homes Redmond "Don Guillett" wrote: How did they become bolded? -- Don Guillett SalesAid Software "Rich D" wrote in message ... I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
Rich
Color the cells then use the SumByColor Function from Chip Pearson's site. http://www.cpearson.com/excel/colors.htm Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 08:24:01 -0800, Rich D wrote: Also, I could make them a certain color or whatever...Can I add only those numbers in a column with certain characteristics? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
I would do this via Word. Copy the column to Word. Use Edit, Replace in Word
to remove numbers that are not bold. Copy the remaining numbers to a different column in Excel and add. "Rich D" wrote: I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
Word? Is that some kind of program? Who needs it?
-- Don Guillett SalesAid Software "Martin P" wrote in message ... I would do this via Word. Copy the column to Word. Use Edit, Replace in Word to remove numbers that are not bold. Copy the remaining numbers to a different column in Excel and add. "Rich D" wrote: I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
I am not sure if you are being facetious. I believe Search and Replace to be
the one area where Word is much more powerful than Excel. "Don Guillett" wrote: Word? Is that some kind of program? Who needs it? -- Don Guillett SalesAid Software "Martin P" wrote in message ... I would do this via Word. Copy the column to Word. Use Edit, Replace in Word to remove numbers that are not bold. Copy the remaining numbers to a different column in Excel and add. "Rich D" wrote: I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
No, I wouldn't claim to be that witty. I do think it funny to go thru the
procedure you describe to do a search. Perhaps you can give an serious example of what Excel can't find that this convoluted procedure can.?? -- Don Guillett SalesAid Software "Martin P" wrote in message ... I am not sure if you are being facetious. I believe Search and Replace to be the one area where Word is much more powerful than Excel. "Don Guillett" wrote: Word? Is that some kind of program? Who needs it? -- Don Guillett SalesAid Software "Martin P" wrote in message ... I would do this via Word. Copy the column to Word. Use Edit, Replace in Word to remove numbers that are not bold. Copy the remaining numbers to a different column in Excel and add. "Rich D" wrote: I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Add only the BOLDED numbers in a column.
Somewhere in these discussions I made a similar suggestion which was well
received by the original poster. I do not seem to be able to trace that thread. If you consider Excel and Visual Basic to be separate entities, then the question in this thread would be an example. If not, then I would not say this method can do what Excel cannot do. It is a tool just as Visual Basic is a tool. The only comment that I can make is that in Search and Replace one can get by without Visual Basic, which does require specialised knowledge. Having said all this, I must admit that your macro suggestion is a neat and efficient solution. "Don Guillett" wrote: No, I wouldn't claim to be that witty. I do think it funny to go thru the procedure you describe to do a search. Perhaps you can give an serious example of what Excel can't find that this convoluted procedure can.?? -- Don Guillett SalesAid Software "Martin P" wrote in message ... I am not sure if you are being facetious. I believe Search and Replace to be the one area where Word is much more powerful than Excel. "Don Guillett" wrote: Word? Is that some kind of program? Who needs it? -- Don Guillett SalesAid Software "Martin P" wrote in message ... I would do this via Word. Copy the column to Word. Use Edit, Replace in Word to remove numbers that are not bold. Copy the remaining numbers to a different column in Excel and add. "Rich D" wrote: I have a column of numbers and some of them are in boldface. How can I add only the boldfaced numbers in the column? Rich -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| how write excel formula numbers in column => &=< between 20-40 | New Users to Excel | |||
Linear Mode
