Excel calculation
Hi all,
Newbie question. I want to calculate an overall score
where sometimes I have a NA field (not available score.
In the example below, I would like to calculate SUM Row 1
to Row 7 and only divide by the number of rows with actual
numbers...in this case it would be (13 / 4). Please help.
Thanks.
Martin
Row Score
1 2
2 3
3 NA
4 5
5 3
6 NA
7 NA
|