specific If Statement

[Excel Noobie]

Is there any way I can sum only specific cells that have a yellow background without having to select each one myself? Maybe an if statement or whatever formula is easiest. Any help would be greatly appreciated.

Excel Noobie

[VBA Noob]

Hi,

You need some code. Try the attached link under

Summing The Values Of Cells With A Specific Color

http://www.cpearson.com/excel/colors.htm

More on VBA can be find here

http://www.mcgimpsey.com/excel/modules.html

VBA Noob

[MDubbelboer]

Hi,

You need some code. Try the attached link under

Summing The Values Of Cells With A Specific Color

http://www.cpearson.com/excel/colors.htm

More on VBA can be find here

http://www.mcgimpsey.com/excel/modules.html

VBA Noob

Nice. Thanks, I've actually been curious about this for some time but kept forgetting to look for an answer

[VBA Noob]

No Problem

Good luck

VBA Noob