Using SUMIF function and conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BSM - 24 May 2008 12:12 GMT

Hi,

I have a column of mumbers in which few numbers are filled with blue color,
can I give a formula to add the cells that are colored?

Signature

Regards,
Malini S

Reply to this Message

Mike H - 24 May 2008 12:15 GMT

Hi,

You can't sum by colours with a formula, you need a macro, but you can sum
by the conditional format that set the colour. If you post the conditional
format then someone will help.

Mike

> Hi,
>
> I have a column of mumbers in which few numbers are filled with blue color,
> can I give a formula to add the cells that are colored?

Reply to this Message

Bob Phillips - 24 May 2008 14:28 GMT

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
> I have a column of mumbers in which few numbers are filled with blue
> color,
> can I give a formula to add the cells that are colored?

Reply to this Message