Conditional Summing Cell Range
 

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.

Conditional Summing Cell Range
 

Chip Pearson details how to do this at:

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

Regards,
Tom Ogilvy


jlfox wrote in message
om...
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.

Conditional Summing Cell Range
 

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




"jlfox" wrote in message
om...
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.