D
DAN SAVAGE
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?
WHICH i SPECIFY.
WHAT DO I ENTER FOR THE CRITERIA ARGUMENT?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
B
Bob Phillips
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)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
R
Ray Pendergast
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.
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.
M
Max
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
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