i have a workbook, where i create one sheet per employee, the sheet is named after the employee. The sheet has two columns Variable and Values.
The Variables will differ for departments
I create a summary sheet where i will list all the variables in one column and sum the values from the employees Logically it goes like this
IF Summary.c16 = (andy.c16) then count = count + 1 IF Summary.c16 = bob.c16 then count = count +1
Like this the value in C16 is compared with value of all sheets
for sum part i can use SUM(first:last!AD16) but comparing one value to all cells is what i got stumped I was suggested to use Indirect
but here the sheet names are to be like Sheet1, sheet 2 ... but in my case sheet names are different
Please help and guide me