Can I push my luck please and ask another question
In column A1:A5 I have numeric values with a total, this is a set target
In column B1:B5 I have numeric values that I enter in as a score
I then divide total of column B in A for the actual percentage score
If I enter N/A into any of the B1:B5 cells I would like the Target reduced in the opposite cell in A1:A5
Example1
A B
2 1
2 2
2 1
1 1
2 2
9 7 = 77.8% totals
Example2
A B
2 1
2 n/a
2 1
1 1
2 2
7 5 = 71.4% totals
maybe a sumif type statement in the total sum saying not to add value in A1 if B1 has N/A and so on
In column A1:A5 I have numeric values with a total, this is a set target
In column B1:B5 I have numeric values that I enter in as a score
I then divide total of column B in A for the actual percentage score
If I enter N/A into any of the B1:B5 cells I would like the Target reduced in the opposite cell in A1:A5
Example1
A B
2 1
2 2
2 1
1 1
2 2
9 7 = 77.8% totals
Example2
A B
2 1
2 n/a
2 1
1 1
2 2
7 5 = 71.4% totals
maybe a sumif type statement in the total sum saying not to add value in A1 if B1 has N/A and so on