Countif statement

mysticeyes

New Member
Joined
Mar 17, 2004
Messages
2
Hi ~~~

I am trying to write a combination IF statement. What I need it to do is

If the month is January and your name is Joe Dirt count 1
(on this example it would be 3)

A B C
Date Name Manager
2/1/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Martinez
2/3/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Jones
1/1/2003 Joe Dirt Martinez

How would you put that a formula? o_O

Any help would be GREATLY appriciated!!!! thax
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Two methods --
Book5
ABCDEFG
1DateNameManager1JoeDirt3
22/1/2003JoeDirtJones
31/2/2003JoeDirtMartinez
42/3/2003JoeDirtJones
51/2/2003JoeDirtJones
61/1/2003JoeDirtMartinez
7
8DateNameManagerConcat1JoeDirt3
92/1/2003JoeDirtJones2JoeDirt
101/2/2003JoeDirtMartinez1JoeDirt
112/3/2003JoeDirtJones2JoeDirt
121/2/2003JoeDirtJones1JoeDirt
131/1/2003JoeDirtMartinez1JoeDirt
Sheet1
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201

ADVERTISEMENT

The year test should be added, unless any january from any year would be acceptable.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
I *do* keep forgetting that, don't I, Aladin. As amended --
Book5
ABCDEFG
1DateNameManager12003JoeDirt3
22/1/2003JoeDirtJones
31/2/2003JoeDirtMartinez
42/3/2003JoeDirtJones
51/2/2003JoeDirtJones
61/1/2003JoeDirtMartinez
7
8DateNameManagerConcatJanuary-03JoeDirt3
92/1/2003JoeDirtJones22003JoeDirt
101/2/2003JoeDirtMartinez12003JoeDirt
112/3/2003JoeDirtJones22003JoeDirt
121/2/2003JoeDirtJones12003JoeDirt
131/1/2003JoeDirtMartinez12003JoeDirt
Sheet1
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844

ADVERTISEMENT

COUNTIF seems to work summing up the total Joe Dirt

=COUNTIF(B2:B6,"*Joe Dirt*")

But, it does not filter by date....
Is there a way to do a simple COUNTIF with a date filter?
I can't seem to find anything, but it intrigues me, since it would be simpler if possible.

(y)
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Ta

And I thought UNIQUEVALUES might be useful, but alas and alack...

:wink:
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Aladin,


Would your solution be applicable to a one column data-set?
If so, just broadly, how?
I am moderately confused about that.

I am looking to apply it to Name, Phrases, and Initials.

It could be that I should be looking at other function areas.

I am not sure yet.

Ta

(y)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,538
Messages
5,596,750
Members
414,097
Latest member
FaeFen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top