formula question
 

if this formula works on one sheet, how would i get it to sum multiple sheets,
say sheet1:sheet3?

=COUNTIF(L3:L33,"=r")

--


Gary

formula question
 

Gary,

Put the names of each the sheets in M1:M3, or however many you need, and use

=SUMPRODUCT(COUNTIF(INDIRECT(M1:M3&"!L3:L33"),"r") )

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if this formula works on one sheet, how would i get it to sum multiple
sheets,
say sheet1:sheet3?

=COUNTIF(L3:L33,"=r")

--


Gary

formula question
 

thanks for the formula, bob.

--


Gary


"Bob Phillips" wrote in message
...
Gary,

Put the names of each the sheets in M1:M3, or however many you need, and use

=SUMPRODUCT(COUNTIF(INDIRECT(M1:M3&"!L3:L33"),"r") )

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if this formula works on one sheet, how would i get it to sum multiple
sheets,
say sheet1:sheet3?

=COUNTIF(L3:L33,"=r")

--


Gary