Multiple condition countif for excel 2003
 

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.

Multiple condition countif for excel 2003
 

=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.

Multiple condition countif for excel 2003
 

HI,

say I have table like this:

A B
X 1
X 1
X 0
X 1
1
X 0

so, i would like to count all that that fulfill X in column A and 1 in
column B.
the answer should be 3.

Thanks.


"Stefi" wrote:

=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.

Multiple condition countif for excel 2003
 

=SUMPRODUCT(--(A1:A6="X"),--(B1:B6=1))
Warning! You have to adjust ranges to your real needs! In Excel 2003 you
can't refer to entire columns (like A:A)! (In excel 2007 yes!)

Regards,
Stefi


€žgoayimm€� ezt Ã*rta:

HI,

say I have table like this:

A B
X 1
X 1
X 0
X 1
1
X 0

so, i would like to count all that that fulfill X in column A and 1 in
column B.
the answer should be 3.

Thanks.


"Stefi" wrote:

=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.

Multiple condition countif for excel 2003
 

YAY it works!
thanks

=)

"Stefi" wrote:

=SUMPRODUCT(--(A1:A6="X"),--(B1:B6=1))
Warning! You have to adjust ranges to your real needs! In Excel 2003 you
can't refer to entire columns (like A:A)! (In excel 2007 yes!)

Regards,
Stefi


€žgoayimm€� ezt Ã*rta:

HI,

say I have table like this:

A B
X 1
X 1
X 0
X 1
1
X 0

so, i would like to count all that that fulfill X in column A and 1 in
column B.
the answer should be 3.

Thanks.


"Stefi" wrote:

=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.

Multiple condition countif for excel 2003
 

You are welcome! Thanks for the feedback!
Stefi

€žgoayimm€� ezt Ã*rta:

YAY it works!
thanks

=)

"Stefi" wrote:

=SUMPRODUCT(--(A1:A6="X"),--(B1:B6=1))
Warning! You have to adjust ranges to your real needs! In Excel 2003 you
can't refer to entire columns (like A:A)! (In excel 2007 yes!)

Regards,
Stefi


€žgoayimm€� ezt Ã*rta:

HI,

say I have table like this:

A B
X 1
X 1
X 0
X 1
1
X 0

so, i would like to count all that that fulfill X in column A and 1 in
column B.
the answer should be 3.

Thanks.


"Stefi" wrote:

=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.