Conditional Summing Cell Range

jlfox · Jul 12, 2003

I have a cell range that consist of different colors (blue,red,yellow.
I would like to sum data in the range but only if the cell color is a
specfic color.

Example:
My cell range is F4:F100
The range name is seats
I want to sum all blue colored cells
and place the total in the L4 cell.

My problem is refering to the blue cells only.

Thanks for your help.

Tom Ogilvy · Jul 12, 2003

Chip Pearson details how to do this at:

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

Regards,
Tom Ogilvy

Chip Pearson · Jul 12, 2003

See www.cpearson.com/excel/colors.htm for some VBA code to do
exactly this.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Conditional Summing Cell Range

jlfox

Tom Ogilvy

Chip Pearson