M
Melody
A B C D
1 2.0 1.0 U 3.5
2 2.3 2.0 3.1
3 2.5 1.3 I 2.5
4 =Avg(A1:A3)
I have made columns B & C separate even though it is one entry to distingish
between text and a number. I would like to perform an operation on a number
only if there is not a letter beside it OR only if there is a certain letter
beside it. How would I write: Sum of all numbers in column B (without a
letter next to it in column C OR with the letter I next to it in column C)
and then divide the result by the number of entries that were summed and
multiply by 100? Was I correct to put the "Letters" in column C or could they
have been in column B as well?
Thank you--
Melody
1 2.0 1.0 U 3.5
2 2.3 2.0 3.1
3 2.5 1.3 I 2.5
4 =Avg(A1:A3)
I have made columns B & C separate even though it is one entry to distingish
between text and a number. I would like to perform an operation on a number
only if there is not a letter beside it OR only if there is a certain letter
beside it. How would I write: Sum of all numbers in column B (without a
letter next to it in column C OR with the letter I next to it in column C)
and then divide the result by the number of entries that were summed and
multiply by 100? Was I correct to put the "Letters" in column C or could they
have been in column B as well?
Thank you--
Melody