My Excel Formula abilities are...rubbish..
What I'm trying to do is
In Cells B4 - AE4 there are a series of 1's and 2's and some of the cells are blank
I need it so in cell AG4 and AH4 it totals the number of 1's and 2's
for example if its set out as below:
1 - 1 - 1 - 2 - 1 - 2 - 2 - Blank - Blank - 2 - 1 I want to display in AG4 the total number of 1's being 5 and in AH4 the total number of 2's being 4
Can anyone help please?
Ta,
Jake
What I'm trying to do is
In Cells B4 - AE4 there are a series of 1's and 2's and some of the cells are blank
I need it so in cell AG4 and AH4 it totals the number of 1's and 2's
for example if its set out as below:
1 - 1 - 1 - 2 - 1 - 2 - 2 - Blank - Blank - 2 - 1 I want to display in AG4 the total number of 1's being 5 and in AH4 the total number of 2's being 4
Can anyone help please?
Ta,
Jake