M medicenpringles Nov 18, 2004 #1 well that would work.. but the cell references i'm using are B9:23 *and B27. how do you do that
B Bob Phillips Nov 18, 2004 #2 =if(COUNTA(B9:B23)+COUNTA(B27)=15, "do it",") -- HTH RP (remove nothere from the email address if mailing direct)
=if(COUNTA(B9:B23)+COUNTA(B27)=15, "do it",") -- HTH RP (remove nothere from the email address if mailing direct)