There are at least two ways to do this without VBA:

METHOD 1

requires an additional column, e.g. W. Each cell in the W column range contains the formula:

=IF(Vr<>0,Ur,"") where r = the row number.

The cell to contain the result (e.g. X1) uses the formula:

=COUNTIF(Wr:Wr+n,"<45")+COUNTIF(Wr:Wr+n,">135") where r is the 1st row number and n is the number of rows in evaluated range. {alternate: =COUNTIF(W:W,"<45")+COUNTIF(W:W,">135")}

METHOD TWO

uses the DCOUNT function. The formula in cell X1 is:

=DCOUNT(U4:V12,"Ucol",U1:V2)+DCOUNT(U4:V23,"Ucol", V1:W2)

The data names âUcolâ and âVcolâ can be anything you like, but they have to match as shown.

If the âUcolâ conditions had conjoined rather than disjoined (e.g. >45 and <135) the formula would have been simpler:

=DCOUNT(U4:V12,"Ucol",U1:W2)

It's difficult to make clear in this format, and I don't have rights to post HTML here, so a sample spreadsheet (xl2000) is available at:

http://click.officeliveemail.com/?ju=fe5912767263067a7517&ls=fdef1672736d0275771576 73&m=fef012797d6206&l=fec51c7677610478&s=fe1a12727 c600378731d75&jb=ff62127775&t=
for anyone interested.