Airfix9
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 886
Hi all,
Having a senior moment.
What I have is a list of outlets in column A and then, in columns B, C and D a 1 if they stock a particular model (one column for each model).
What I want to do is to count the number of times that an outlet stocks at least one of the models. That is to say, if the sum of columns B, C and D is 1 or more, count it.
Ideas greatly received.
Having a senior moment.
What I have is a list of outlets in column A and then, in columns B, C and D a 1 if they stock a particular model (one column for each model).
What I want to do is to count the number of times that an outlet stocks at least one of the models. That is to say, if the sum of columns B, C and D is 1 or more, count it.
Ideas greatly received.