View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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