Need help with Countif Formule

[Captain Randy]

Working in Excel 2007

In rows A1:C1..... the letters are red in color
The next set of row or rows A2:C8.....
the letters are BLUE in color...
I want to be able to count how many RED and how many BLUE lines I have on these sheets.
Something like this; =Countifs (A1:C136,[RED])
But to my "Thinking" this dosen't work at all.
Then I could copy and pasta the formule as I work alone to complet this.

What I have read on the internet is using VBA. That my friend is very dangerous for someone that dose not know how to spell VBA to start with!
Any help from some of you pros would be a great help.
Thank You, in advance for your help.
Randy

 

[T. Valko]

Working in Excel 2007

In rows A1:C1..... the letters are red in color
The next set of row or rows A2:C8.....
the letters are BLUE in color...
I want to be able to count how many RED and how many BLUE lines I have on these sheets.
Something like this; =Countifs (A1:C136,[RED])
But to my "Thinking" this dosen't work at all.
Then I could copy and pasta the formule as I work alone to complet this.

What I have read on the internet is using VBA. That my friend is very dangerous for someone that dose not know how to spell VBA to start with!
Any help from some of you pros would be a great help.
Thank You, in advance for your help.
Randy

Maybe you can construct a formula that counts based on WHY the cells are red or blue?

I think you should avoid doing calculations based on formats. It doesn't work the way you think it works!

 

[Captain Randy]

Thank You, T.Valko

The reason they are Red is items going out the door and the Blue Items are items coming in the door.

So it is in my lap and now I must try to comeup with somthing.
As long as Excel has been around, I would have thought that Excel could count, numbers letters symbols and color, given the correct information.

I wonder why we can change colors in cells to read minus as $25.15
but then we can not count colors..
We learn something new each day.
Thank You for your input.

 

[Aladin Akyurek]

Working in Excel 2007

In rows A1:C1..... the letters are red in color
The next set of row or rows A2:C8.....
the letters are BLUE in color...
I want to be able to count how many RED and how many BLUE lines I have on these sheets.
Something like this; =Countifs (A1:C136,[RED])
But to my "Thinking" this dosen't work at all.
Then I could copy and pasta the formule as I work alone to complet this.

What I have read on the internet is using VBA. That my friend is very dangerous for someone that dose not know how to spell VBA to start with!
Any help from some of you pros would be a great help.
Thank You, in advance for your help.
Randy

See, e.g.:

http://www.cpearson.com/excel/colors.aspx

for color counting.

 

[T. Valko]

See, e.g.:

http://www.cpearson.com/excel/colors.aspx

for color counting.

Make sure you read this section of the article:

Color Change And Calculation

 

[Captain Randy]

Thank You very much, "T Valko and Aladin Akyurek"

Captain Randy

 

[T. Valko]

Thank You, T.Valko

The reason they are Red is items going out the door and the Blue Items are items coming in the door.

So it is in my lap and now I must try to comeup with somthing.
As long as Excel has been around, I would have thought that Excel could count, numbers letters symbols and color, given the correct information.

I wonder why we can change colors in cells to read minus as $25.15
but then we can not count colors..
We learn something new each day.
Thank You for your input.

It can be done, I just think it's not a good idea.

Here's why...

The problem is that changing a cell format does not cause a calculation to take place.

If you count based on a font color, and then you change that font color, the formula you used to count based on that font color will not automatically update so the result of the formula will be incorrect.

If you can use cells that mark the items as "In" or "Out" then getting the count would be relatively simple.

=COUNTIF(A2:A10,"In")
=COUNTIF(A2:A10,"Out")