Feedback if not clear or if it is!
Tx

"Lerner" wrote:

First, I'm not one of the experts in this group, as a matter of fact I'm new
at XL, but I improvise a lot, and as XL does not do
interpretation of colors, this is what I do:
In XL 2007 I can filter by color.(after auto filtering the data)
Then in any cell I apply this formula to SUM the amount in column F
=subtotal(9,F2:F4545)
change the ranges as needed.
NOW, if you need to count items then wait for the answer I posted previous to
your question( if that can be done).
We, however, need some light from the experts regarding these statements.
THANKS.
"angelico" wrote:

I should have been more precise. I have XL2007. My question is how? Thanks
--
angelico


"Lerner" wrote:

Only in XL 2007

"angelico" wrote:

Can I sum a column based on the colors of the cells. Thua add all red, all
gree, etc.
--
angelico

Very clear. Excellent. A shame that given the ability to filter by a color
they didn't allow a cell with a color to be used as an argument in "sumif"
Thanks
--
angelico


"Lerner" wrote:

Feedback if not clear or if it is!
Tx

"Lerner" wrote:

First, I'm not one of the experts in this group, as a matter of fact I'm new
at XL, but I improvise a lot, and as XL does not do
interpretation of colors, this is what I do:
In XL 2007 I can filter by color.(after auto filtering the data)
Then in any cell I apply this formula to SUM the amount in column F
=subtotal(9,F2:F4545)
change the ranges as needed.
NOW, if you need to count items then wait for the answer I posted previous to
your question( if that can be done).
We, however, need some light from the experts regarding these statements.
THANKS.
"angelico" wrote:

I should have been more precise. I have XL2007. My question is how? Thanks
--
angelico


"Lerner" wrote:

Only in XL 2007

"angelico" wrote:

Can I sum a column based on the colors of the cells. Thua add all red, all
gree, etc.
--
angelico

You're very welcome, glad I could help.
I think there is another way using macro and/or functions,
but the answer will come from the nice people that help us daily.

"angelico" wrote:

Very clear. Excellent. A shame that given the ability to filter by a color
they didn't allow a cell with a color to be used as an argument in "sumif"
Thanks
--
angelico


"Lerner" wrote:

Feedback if not clear or if it is!
Tx

"Lerner" wrote:

First, I'm not one of the experts in this group, as a matter of fact I'm new
at XL, but I improvise a lot, and as XL does not do
interpretation of colors, this is what I do:
In XL 2007 I can filter by color.(after auto filtering the data)
Then in any cell I apply this formula to SUM the amount in column F
=subtotal(9,F2:F4545)
change the ranges as needed.
NOW, if you need to count items then wait for the answer I posted previous to
your question( if that can be done).
We, however, need some light from the experts regarding these statements.
THANKS.
"angelico" wrote:

I should have been more precise. I have XL2007. My question is how? Thanks
--
angelico


"Lerner" wrote:

Only in XL 2007

"angelico" wrote:

Can I sum a column based on the colors of the cells. Thua add all red, all
gree, etc.
--
angelico