M
MISSY371
Hello,
I need a formula that looks up a value in row 1 on sheet2 and returns the
count of a range in the colmun that matches the lookup in sheet1. For
example:
Sheet2 - Feed Sheet
Smithfield
RSM John Doe
ASM Jenn Smith
ASM2 Brian Smith
So Smithfield has 1 RSM and 2 ASMs
Sheet1
RSM ASM
Smithfield 1 2
So I want a formula to return the count of how many RSM's and ASM's are in a
specific location. I have this:
=(HLOOKUP(A1,Sheet2!A1:A6,(COUNTA(Sheet2!A5:A6)),FALSE)) but it's just
returning 0. Any suggestions?
I need a formula that looks up a value in row 1 on sheet2 and returns the
count of a range in the colmun that matches the lookup in sheet1. For
example:
Sheet2 - Feed Sheet
Smithfield
RSM John Doe
ASM Jenn Smith
ASM2 Brian Smith
So Smithfield has 1 RSM and 2 ASMs
Sheet1
RSM ASM
Smithfield 1 2
So I want a formula to return the count of how many RSM's and ASM's are in a
specific location. I have this:
=(HLOOKUP(A1,Sheet2!A1:A6,(COUNTA(Sheet2!A5:A6)),FALSE)) but it's just
returning 0. Any suggestions?