Sum cells based on color in Mac 2008

I am trying to SUM cells in Excel 2008 based on the cell's background color. I know there is a way to create a formula for this if you are using PC versions of Excel, but I can't figure out how to do it for Excel 2008. Do I need to use Applescript? If so, what do I need to do?

Thanks.