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