View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default the sum of all bolded numbers

You could use a UDF

Function SumBold(rng As Range)
Dim cell As Range
For Each cell In rng
If IsNumeric(cell.Value) Then
If cell.Font.Bold Then
SumBold = SumBold + cell.Value
End If
End If
Next cell
End Function


Call such as =SumBold(A2:a20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sam12345" wrote in
message ...

i have a column of prices (ie - $25, $40...) and i want to be able to
acquire only the sum of the numbers that i bold in that paticular
column while keeping the unbolded numbers ignored for the equation
is this at all possible, if so how?
thanks for any help


--
Sam12345
------------------------------------------------------------------------
Sam12345's Profile:

http://www.excelforum.com/member.php...o&userid=11882
View this thread: http://www.excelforum.com/showthread...hreadid=486695