vlookup and if, I think
Thanks for your answer. I am sure that is the correct function, although it
doesn't work correctly in all cases. I think this is because I have merged
cells in the worksheet. I don't want to bother you too much, but can I
possibly send you the worksheet so you can check this? I really need this to
work properly. Thanks in advance.
Regards,
Emece.-
"Emece" wrote:
I have the following data:
Client January February March (and so on until December)
A 1 1 1 1 1 1 1 1
B 1 1 1 1 1 1
Each time I visit a client, I enter a 1 in the corresponding cell. I want to
detail, in a separate range, how many times I visit a client in each month.
Trying to clarify a bit mo I want to have a list in a cell with the
clients, a list in another cell with the months, and when I choose for
example A, February, to obtain a 3.
Is this possible?
Thanks in advance,
Regards,
Emece.-
|