COUNT IF Help with multiple conditions

[potentus]

Hi,

I have been trying to find a formula for this and have had no success
I have multiple columns in a spreadsheet,with 2000 rows of numbers.


I want the total number of times: both number 2 appears in column a
AND number 5 appears in column b

Is this possible?

thanks

 

[Teethless mama]

=SUMPRODUCT(--(A1:A2000=2),--(B1:B2000=5))

 

[willfeld]

just add two count ifs together =countif(column a range)+countif(column b
range)

 

[ryguy7272]

A Pivot Table will do that for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan--

 

[potentus]

A Pivot Table will do that for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan--

Hi,

Thanks for the Quick reponses.

I believe I did not communication exactly what I am looking for:

I want the to count only those instances where 2 appears in column A
AND 5 also appears in columns B

Thanks for the help

zach