Thank you for your reply. Thats what I have done in the meantime, but I
really need one cell total for every time Lenny appears in Column H and if
Kat or Pam appear in Column K on the same row. I think I have a punctuation
error somewhere in my previous formula and I also think the *AND is wrong
=COUNTIF((Green!:Montana!H2:H500,"Lenny")*AND(Gree n!:Montana!K2:K500,"kat"))
Any other suggestions? Thanks!
"BlueDaze" wrote:
In your range you need to select one sheet at a time. You might have to
do a countif for each sheet and then add them all up.
--
BlueDaze
------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=469781