calculate sum of highlighted cells in a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ac experts - 20 Mar 2008 00:40 GMT

Is there a formula to add the sum of all highlighted cells only in a column
with both no fill and highlighted cells.

Reply to this Message

Gary''s Student - 20 Mar 2008 00:56 GMT

See:

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

Signature

Gary''s Student - gsnu200774

> Is there a formula to add the sum of all highlighted cells only in a column
> with both no fill and highlighted cells.

Reply to this Message

Gord Dibben - 20 Mar 2008 00:59 GMT

What do you consider "highlighted"? Colored cells?

You would need to use VBA to SUM colored cells.

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

If the cells are colored due to Conditional Formatting you could SUM based upon
the CF criteria.

If you just want to get a SUM on the Status Bar try the following method if you
have Excel 2003 and all colored cells are same color...............

Select the column then Edit>Find>Format>Pattern. Select the pattern and OK.

In the Found Dialog hit SHIFT + DownArrow

On Status Bar see SUM = xxx

Gord Dibben MS Excel MVP

>Is there a formula to add the sum of all highlighted cells only in a column
>with both no fill and highlighted cells.

Reply to this Message

ac experts - 20 Mar 2008 01:16 GMT

Yes colored. I have a column of cells and i color them yellow with the fill
color button. Now I want to the sum of only the yellow cells, and if I color
more cells in the same column I want them to be totaled also.

> What do you consider "highlighted"? Colored cells?
>
[quoted text clipped - 18 lines]
> >Is there a formula to add the sum of all highlighted cells only in a column
> >with both no fill and highlighted cells.

Reply to this Message

Gord Dibben - 20 Mar 2008 04:04 GMT

I guess you are stuck with the VBA solution found at Chip's site.

His SumByColor function is what you want.

You would copy and paste the Function to a general module in your workbook.

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

Gord

>Yes colored. I have a column of cells and i color them yellow with the fill
>color button. Now I want to the sum of only the yellow cells, and if I color
[quoted text clipped - 22 lines]
>> >Is there a formula to add the sum of all highlighted cells only in a column
>> >with both no fill and highlighted cells.

Reply to this Message