Countif function with two ranges, possible?

[bash]

Hi,

I'm trying to use the COUNTIF function to count the number of cells
that have a value >= 1. The problem is that the cells I have are split
into two ranges:

=COUNTIF(AU3:BA3:BK3:BM3,">=1") does not work. Does anyone know how I
should re-write the formula (or use another one)?

Range 1: AU3:BA3
Range 2: BK3:BM3

Thanks in advance. This forum is usually great.

/Daniel

 

[Dave Peterson]

Just can add them yourself:

=countif(au3:ba3,">="&1) + countif(bk3:bm3,">="&1)

 

[bash]

Just can add them yourself:

=countif(au3:ba3,">="&1) +countif(bk3:bm3,">="&1)

Thanks!