Counting Formula

[Mote36]

I need to count some results that have criterias in two diferents rows. I'm using excel 2000.

 

[Scott Huish]

Say you want to count on row 1 the cells that equal 1 and the cells on row 3 equal 3:

=SUMPRODUCT(--($A$1:$Z$1=1),--($A$3:$Z$3=3))

 

[Mote36]

I need to count in A1:A10 all the values that are iquals to 23 in A1:A10 and iquals to 2008 in B1:B10.

 

[Scott Huish]

Just change the ranges and conditions:

=SUMPRODUCT(--($A$1:$A$10=23),--($B$1:$B$10=2008))