Countif

S

Steve

Can I do a countif using only specific cells. for example, a3,a15,a27?

Thanks for any help you can offer,
Steve
 
B

Bob Phillips

Steve,

If it is a regular sequence as you suggest, you could use

=SUMPRODUCT(--(MOD(ROW(Y1:Y27),12)=3),--(Y1:Y27="a"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top