ExcelBanter - Sum by color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum by color (https://www.excelbanter.com/excel-discussion-misc-queries/75489-sum-color.html)

TheHaze6990

Sum by color

Is there a way to sum a group of numbers by color?

--
TheHaze6990
Posted from - http://www.officehelp.in

JE McGimpsey

Sum by color

See

http://cpearson.com/excel/colors.htm

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?

Osprey

Sum by color

Just what I need but - tried it and get errors with #NAME? returned in the
function calling cell - any ideas?

SE

"JE McGimpsey" wrote:

See

http://cpearson.com/excel/colors.htm

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?

Dave Peterson

Sum by color

Make sure you put the code in a general module--not behind a worksheet, not
behind ThisWorkbook.

Osprey wrote:

Just what I need but - tried it and get errors with #NAME? returned in the
function calling cell - any ideas?

SE

"JE McGimpsey" wrote:

See

http://cpearson.com/excel/colors.htm

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?

--

Dave Peterson

All times are GMT +1. The time now is 02:52 PM.