I have 12 worksheets starting from Jan. to Dec.. There are staff names
in the A column in each worksheet and most of them are in the same row
on each worksheet. I have created names in the left column according to
the staff names and set up an formula in a defined column e.g. AG

10/01 10/02.......... 10/31
Davis Chan v v v =Sum((Davis_Chan="V")*1)
Ada Au v =Sum((Ada_Au="V")*1)

But I couldn't figure out a formula to count the string "V" for
all "Davis Chan" in all worksheets since "Davis Chan" can be in
different rows in all worksheets. Does anybody have any idea if I want
to put the new formula in a separate worksheet ?

Louis