Is there a way to count formated cells like shaded cells
and come up with a total. Countif doesn't work with
formatting to my knowledge.

See:

http://www.xldynamic.com/source/xld.ColourCounter.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to count formated cells like shaded cells
and come up with a total. Countif doesn't work with
formatting to my knowledge.
.

Will this work for simply counting, like counta, for a
color filled cell?
-----Original Message-----
See:

http://www.xldynamic.com/source/xld.ColourCounter.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to count formated cells like shaded cells
and come up with a total. Countif doesn't work with
formatting to my knowledge.
.

.

No, using the formula shown it can be extended to sum that values in those
cells, or other cells, as well.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
...
Will this work for simply counting, like counta, for a
color filled cell?
-----Original Message-----
See:

http://www.xldynamic.com/source/xld.ColourCounter.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to count formated cells like shaded cells
and come up with a total. Countif doesn't work with
formatting to my knowledge.
.

.