sumif, criteria, fill color
 

I WANT TO SUM VALUES IN A SPECIFIED RANGE THAT HAVE A YELLOW FILL COLOR,
WHICH i SPECIFY.
WHAT DO I ENTER FOR THE CRITERIA ARGUMENT?

sumif, criteria, fill color
 

See

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

In article ,
DAN SAVAGE <DAN wrote:

I WANT TO SUM VALUES IN A SPECIFIED RANGE THAT HAVE A YELLOW FILL COLOR,
WHICH i SPECIFY.
WHAT DO I ENTER FOR THE CRITERIA ARGUMENT?

sumif, criteria, fill color
 

See http://xldynamic.com/source/xld.ColourCounter.html

--
---
HTH

Bob

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



"DAN SAVAGE" <DAN wrote in message
...
I WANT TO SUM VALUES IN A SPECIFIED RANGE THAT HAVE A YELLOW FILL COLOR,
WHICH i SPECIFY.
WHAT DO I ENTER FOR THE CRITERIA ARGUMENT?

sumif, criteria, fill color
 

I'm usually a taker in this forum, but today I have something to give. I've
done similar stuff with Conditional Formatting. It's actually kind of the
reverse logic to what you want, but it gives your eye a visual queue that
Excel can also calculate off of. Conditional Formatting is under the Format
menu.
Let's say the data you want to SUMIF on is in column A. Instead of coloring
cells in column A, enter a value in the same row of column B. Conditional
formatting can be set to turn column B cells a specific color for specific
values, and SUMIF can be used to add up whatever is in column A when the
column B value on the same row is a specific value.

"DAN SAVAGE" wrote:

I WANT TO SUM VALUES IN A SPECIFIED RANGE THAT HAVE A YELLOW FILL COLOR,
WHICH i SPECIFY.
WHAT DO I ENTER FOR THE CRITERIA ARGUMENT?

sumif, criteria, fill color
 

To complement Bob's response ..

Try this sample from my archives:
http://www.savefile.com/files/378485
Count n Sum Cells By FillColor_BobPhillips_ColorIndex_UDF.xls
(nicely rendered, full details)

The sample file contains an implementation of Bob Phillips' ColorIndex
Function from his "Processing Coloured Cells" page at:
http://www.xldynamic.com/source/xld.ColourCounter.html
and some examples on how to use the UDF in Excel
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DAN SAVAGE" wrote:
I Want To Sum Values In A Specified Range That Have A Yellow Fill Color,
Which I Specify. What Do I Enter For The Criteria Argument?