Excel Columns - logical sorting options

[donrupika]

Column A : series of numbers from 1-100(random)
Column B : 1's and 2's, randomly

I need to figure out how to write a formula that will count how many occurances of Column A cells that are >13; AND Column B cells that have the number "2"

Can ANYONE HELP???????
Please e-mail your suggestion to donrupika@yahoo.com

Don.

[Philster]

Just use an IF/THEN statement. ie. =IF(A1>13,1,0) this would be over in another row. If number in A1 is greater than 13 then it puts in a 1, if not it puts in a zero. Next is =IF(B1=2,1,0). Copy these down the columns next to your data and then sum the totals at the bottom.

[Tom Urtis]

Try this formula in a cell other than in column A or B:

=COUNTIF(A:A,">13")+COUNTIF(B:B,2)