try this
Sub sumNONitalics()
For Each c In Range("c2:c6")
If c.Font.FontStyle < "Italic" Then mt = mt + c
Next
MsgBox mt
End Sub


--
Don Guillett
SalesAid Software

"stevo" wrote in
message ...

Columns A:B contains videos and their retail price. I want to highlight
in italics the rows of the items which are out of stock.

I want to keep the price of the out of stock items in there for
reference but highlight them in italics. This is so I can predict the
total sales without having to delete these rows.

How do I create a formula that will sum the prices in column B of all
the items except the ones in italics? Is this possible?


--
stevo
------------------------------------------------------------------------
stevo's Profile:
http://www.excelforum.com/member.php...o&userid=10737
View this thread: http://www.excelforum.com/showthread...hreadid=378508