Count word in two columns, one sheet

TXNCPO

New Member
Joined
Nov 1, 2011
Messages
23
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
 

Some videos you may like

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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,456
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Nov 1, 2011
Messages
23
Joe,

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

R/ Joe
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,456
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,877
Members
409,668
Latest member
mitunsLax

This Week's Hot Topics

Top