Thread
:
Conditional Summing Cell Range
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson