Hi!

This would be much easier (and efficient) to do if you were to put a formula
in the same cell on each sheet then sum that cell.

Assume on sheet1 you have:

A1 = Lenny
B1 = Kat
C1 = Pam

On each of the other sheets in cell A1:

=SUMPRODUCT(--(H2:H500=Sheet1!A1),--(ISNUMBER(MATCH(K2:K500,Sheet1!B1:C1,0))))

Then back on Sheet1:

=SUM(Green:Montana!A1)

Biff

"Kat" wrote in message
...
I am trying to count how many times a Sales Rep's name appears and the
corresponding referral source within several worksheets on the same
workbook.
Always same columns (H and K) on each worksheet. First worksheet is
"Green"
Last worksheet is "Montana", Sales Rep name is Lenny and referral source
is
Kat or Pam. I am trying to put in
-COUNTIF((Green!:Montana!H2:H500,"Lenny")*AND(Green !:Montana!K2:K500,"kat"))
What am I doing wrong? Been so long since I learned this stuff...Any help
is much appreciated! Thanks!