Hi all.
Excel 2003.
I need to count not number values using criteria. In the cell to count I
have letters (like A, L, R etc stands for Absent, Leave, Rest etc). THis
count is to be for nation and I have nationalities in unsorted order in an
other cell. I can't use CountIf because cells don't contain number thought
the nation criteria is respected with this function. Using Count or COuntA I
count correctly the values but without the nation criteria. Even Using VBA is
there a way to solve this issue?
My sheet headers are on row 1. Data starts from Row 2 with the following
structu
A= Surname and Name; B= Nationality; C to n= Days number

Thanks in advance for every kind of help or suggestion and for my non
perfect English.
Nicola M.