two conditons

[Julia Ferry]

I have excel 2000.

I am trying to count for two conditions

Column I = 1
and corrosoponding Column J = 1

I would also like a count for
Column J=1 and Column N=Patient discharged

Any help would be awesome

 

[Claus Busch]

Hi Julia,

Am Thu, 08 Mar 2012 16:05:06 GMT schrieb Julia Ferry:

Column I = 1
and corrosoponding Column J = 1
=SUMPRODUCT((I1:I1000=1)*(J1:J1000=1))

I would also like a count for
Column J=1 and Column N=Patient discharged

=SUMPRODUCT((J1:J1000=1)*(N1:N1000="Patient discharged"))


Regards
Claus Busch

 

[Sam Hamman]

I have excel 2000.

I am trying to count for two conditions

Column I = 1
and corrosoponding Column J = 1

I would also like a count for
Column J=1 and Column N=Patient discharged

Any help would be awesome

Not an expert but this might do it if place din cell N2:

IF(AND(I2=1,J2=1,"Patient Discharged",0))