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

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


"potentus" wrote:

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

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


"potentus" wrote:

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

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

Regards,
Ryan--

--
RyGuy


"willfeld" wrote:

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


"potentus" wrote:

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

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

Regards,
Ryan--

--
RyGuy


"willfeld" wrote:

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


"potentus" wrote:

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




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