There is some malware out there but most AV software does not counter that threat.
Almost all of the malware has to be installed by the user, password etc., and the built in app in OS X does a good job of detecting problems.
Personally, I don't run AV on my Macs and don't see the need right now to be overly concerned about it.
AV software for the Mac is, right now, just a waste of processor cycles, IMO
(Now watch the responses!)
P
Is there any value in using Sophos Antivirus for Mac? I know Macs generally don't seem to be much of a target for virus ( I mean, why bother when there are so many fertile PCs out there for virus writers to go after...lol). But I have heard of some Mac attacks out there, no pun intended...

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic