Hi all,
I'm a beginner so excuse if my description of problem isn't great.
I have 2 sheets in a workbook. How do I count in a cell on sheet 2 (call it cell 2A1) how many times a value from another cell on sheet 2 (2A2) appears in a range on sheet 1, say K1:K20. I've managed to do it as a literal value but I want to reference 2A2 in the formula as a variable.
Any help would be appreciated.
Thanks