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