Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sum macro

0 views
Skip to first unread message

Atomic

unread,
Nov 25, 2009, 9:01:02 AM11/25/09
to
I need some help creating a macro which will allow me to add the total sum of
a cell when I change colour.

i.e

Cell D3,H3, K3,K3 is coloured between C3 to R3, I want S3 to have the the
sum of the coloured cells, which is 4? Is that possible?

Thank you.

Jarek Kujawa

unread,
Nov 25, 2009, 9:19:08 AM11/25/09
to
http://cpearson.com/excel/colors.aspx

Eduardo

unread,
Nov 25, 2009, 9:26:02 AM11/25/09
to
Hi,
see

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

and

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

if this helps please click yes thanks

0 new messages