# Count word in two columns, one sheet

#### TXNCPO

##### New Member
Good Morning,

I am attempting to count the word GREEN, (i learned my lesson on colors a while back)

Seems a simple thing, guna feel dumb when this one comes back. Below are two of many attemps. (A5 is where the word GREEN is.

=COUNTIF((A\$10:\$A\$72, \$B\$11:\$B\$57), "GREEN")

=COUNTIF((A\$10:\$A\$72, \$B\$11:\$B\$57), A5)

Thank you.

R/ Joe

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### Joe4

If you have to distinctly different ranges, then use a COUNTIF on each one and add them:
Code:
[COLOR=#333333]=COUNTIF(A\$10:\$A\$72,"GREEN") + C[/COLOR][COLOR=#333333]OUNTIF([/COLOR][COLOR=#333333]\$B\$11:\$B\$57[/COLOR][COLOR=#333333],"GREEN") [/COLOR]

#### TXNCPO

##### New Member
Joe,

Thank you. Again. (tried with "and" earlier, don't know why + did not come to mind)

R/ Joe

You are welcome.

Replies
4
Views
296
Replies
11
Views
133
Replies
2
Views
90
Replies
5
Views
57
Replies
3
Views
37