View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin[_18_] Martin[_18_] is offline
external usenet poster
 
Posts: 1
Default 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