Can you sum a column or row by color? 2

[RyanScharfy]

Example. From A1 to A100 there are a series of cells with various colors. I'd like to sum only the red cells.

Thanks.

 

[AnotherHiggins]

Not without a User Defined Function in VBA. Are you comfortable proceeding with a VBA solution? If not, then you should designate a column and have it marked either YES/NO or 1/0. That really would be the best way to proceed from a data storage point of view, IMHO.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

Have you done a search? This has been answered several times in this forum.

Skip,

_[red][/red]

 

[xlhelp]

As far as I know, only through VBA.

Please post in the VBA forum

Me transmitte sursum, Caledoni!

 

[AnotherHiggins]

I won!! w00t

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[RyanScharfy]

Thanks all.

 

[xlhelp]

OK, Speedy Gonzales..........

Me transmitte sursum, Caledoni!

 

[KenWright]

Unless of course there is a logic behind the red colouring of the cells that can be replicated using a normal function, in which case VBA is not needed

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[firefytr]

Unless of course there is a logic behind the red colouring of the cells that can be replicated using a normal function, in which case VBA is not needed

.. which should of course be our first course of action. Very little we do can compare with the speed/efficiency of the native methods available to us.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci