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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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
Back
Top