i have two columns in excel that have varying numbers and blanks.
kinda like this, below,
A B
1 2 1
2 5 7
3 4
4 8
5 1 3
---------------
= 16 =15
Column A equals 16, and Column B equals 15.
I need something that can figure out the total of Column A and B to equal 100%, and show me what the total percent is for each column separately of A and B.
Sorry, i really don't know how else to ask this,
but thanks in advance for looking
S
kinda like this, below,
A B
1 2 1
2 5 7
3 4
4 8
5 1 3
---------------
= 16 =15
Column A equals 16, and Column B equals 15.
I need something that can figure out the total of Column A and B to equal 100%, and show me what the total percent is for each column separately of A and B.
Sorry, i really don't know how else to ask this,
but thanks in advance for looking
S