COOUNT IF statement with AND?

[gg]

Can I have a Count if "AND" statement? Together?

Countif(AND(.......?

Two criteria must be met before the count?

 

[santeria]

Do you have a detailed example in mind?

 

[Aladin Akyurek]

Given the paucity of information, a general formula:

=SUMPRODUCT(--(Range1=Cond1),--(Range2=Cond2))

 

[Iridium]

Check out http://www.mrexcel.com/td0128.html

HTH

 

[gg]

Ok I may need to go into some detail.

I have table that has 4 columns
A = Dates
B = Names
C = Names2
D = Scores

I want to be able to identify when
Name X had a score for today and yesterday ( Today-1)

also 3 scores in 4 days
and 4 scores in 5 days.

I am trying to determine the effect of being over worked if you will.

In summary I want to know effects of
back to back days.
3 scores in 4 days
4 scores in 5 days

So I am trying to come up with a moving array that I can drag down and it automatically compute.

Make sense?

 

[gg]

I need these to be in different columns
BTB,3N4,4N5

 

[santeria]

The Example given at :

http://www.mrexcel.com/tip031.shtml

Within the Above reference given by Iridium seems to be pertinant ... I think ...

 

[NateO]

What was wrong with Sumproduct?

Ex to Ex.xls
	A	B	C	D
1	01/04/2004	Fred	3
2	01/06/2004	Fred
3	01/05/2004	Fred
4	01/06/2004	Todd
5	01/06/2004	Fred
Sheet3

Edit: Changed the criteria logic.

 

[gg]

Currently the formula that Aladin above gave me working good for the
back to Back.

I am just trying to understand how I can apply it to the others.

3 in 4 days
4 in 5 days

???Any ideas?

 

[just_jon]

Aboot time you posted your layout, eh?