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