L
lintonindy
I'm sure this has been answered before, but I can't find it in the search
If I have values in column B (B3:B18) and enter in values in column C
(C3:C18) and want to find the current total percentage in cell C19 how do I
set up the formula to only add the cells in column B that have values in
Column C?
Example
A B C
Week 1 20 20
Week 2 20 20
Week 3 20 20
Week 4 20 0
Week 5 20 20
Week 6 20 20
Week 7 20 0
Week 8 20 20
Week 9 20 20
Week 10 20 20
Week 11 20 20
Week 12 20 0
Week 13 20 20
Week 14 20 20
Week 15 20
Week 16 20
Current % ?
Since 15 and 16 are "" I can't just add up column C and Divide by the sum of
column B. I also want to be able to adjust from just entering in one grade
Ex: C3
Thank you soooo much for the help
If I have values in column B (B3:B18) and enter in values in column C
(C3:C18) and want to find the current total percentage in cell C19 how do I
set up the formula to only add the cells in column B that have values in
Column C?
Example
A B C
Week 1 20 20
Week 2 20 20
Week 3 20 20
Week 4 20 0
Week 5 20 20
Week 6 20 20
Week 7 20 0
Week 8 20 20
Week 9 20 20
Week 10 20 20
Week 11 20 20
Week 12 20 0
Week 13 20 20
Week 14 20 20
Week 15 20
Week 16 20
Current % ?
Since 15 and 16 are "" I can't just add up column C and Divide by the sum of
column B. I also want to be able to adjust from just entering in one grade
Ex: C3
Thank you soooo much for the help