Countif statement

[mysticeyes]

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?

Any help would be GREATLY appriciated!!!! thax

 

[Aladin Akyurek]

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

Do you have a 10 row sample? Please also indicate on what you're filtering and what you want to count within the filtered result.

 

[santeria]

It is basically a series of Lists of Initials. This example is part of a Day by Day, and Week by Week Sumamary.

Each entry, will have an Initial and a date. These brief examples don't have the date, but they should.

The hope for output would be in separate cells.


Each formula would I guess be essentially the same , but search for one thing alone, an initial and a date, if no date, then the initial would suffice.

But hopefully I would be able to total each Day, then Total the week, and present the Weekly Totals of initials for each Tab.

Production April Call Quality.xls
	G	H	I	J
6	INI.	CM	MSD	ADDV.
7	CM
8	CM
9	AJ	2	1	0
10	AJ
11	AJ
12	MM
13	CB
14	FG
15	KG	5	15	0
16	CM
17	CM
April 5-9

Also, anything in the Initial column may have more than one entry, but not necessarily.



Ta

 

[Aladin Akyurek]

It is basically a series of Lists of Initials. This example is part of a Day by Day, and Week by Week Sumamary.

Each entry, will have an Initial and a date. These brief examples don't have the date, but they should.

The hope for output would be in separate cells.


Each formula would I guess be essentially the same , but search for one thing alone, an initial and a date, if no date, then the initial would suffice.

But hopefully I would be able to total each Day, then Total the week, and present the Weekly Totals of initials for each Tab

Why is the sample not just one column, given your query:

Would your solution be applicable to a one column data-set?

....

Also, anything in the Initial column may have more than one entry, but not necessarily.

You should produce a representative sample. How comes that you simply omit such an essential, probably a complicating aspect of data?

Why don't I see above anything related to my:

"Please also indicate on what you're filtering and what you want to count within the filtered result."

 

[santeria]

Sorry, My morning at the Hospital left me a little scrambled.