Hiya,

Prob confused everyone with that title!

I am trying to ask excel to look at the information that appears in certain cells,add it together and then divide it by another cells data. The problem is the info to add up is not all together so i cant say, for example, =SUM(A1:A5). The cells I need info from are, however, in a pattern of every 8 rows. Example:

C5,C13,C21,C29. Rather than have to type every cell into the formula I am sure you clever people have an easier solution!!

Thanks again

Rob