Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing only coloured cells
Hi, I need to make a sum of some values in a column, but only of those that have been highlighted in yellow. Maybe the answer is simple, can you please help me put the colour of a cell in a formula as a parameter and thus sum only coloured cells? Thanks in advance Regards Max -- maxmil ------------------------------------------------------------------------ maxmil's Profile: http://www.excelforum.com/member.php...o&userid=24396 View this thread: http://www.excelforum.com/showthread...hreadid=382726 |
#2
|
|||
|
|||
http://www.cpearson.com/excel/colors.htm
-- Kind regards, Niek Otten Microsoft MVP - Excel "maxmil" wrote in message ... Hi, I need to make a sum of some values in a column, but only of those that have been highlighted in yellow. Maybe the answer is simple, can you please help me put the colour of a cell in a formula as a parameter and thus sum only coloured cells? Thanks in advance Regards Max -- maxmil ------------------------------------------------------------------------ maxmil's Profile: http://www.excelforum.com/member.php...o&userid=24396 View this thread: http://www.excelforum.com/showthread...hreadid=382726 |
#3
|
|||
|
|||
Hi maxmil,
I need to make a sum of some values in a column, but only of those that have been highlighted in yellow. do NOT highlight with yellow. Have an extra column where users should type "x" or whatever if they want to highlight. Then you an use conditional formats to highlight with yellow and you can use eg. sumif, filters etc. based on the colum with "x". arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Summing non consecutive cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |