SUMIF and COUNTIF help

[towners]

Hello, newbie here again...

This time I want to calculate the average perofrmance % of 8 lines, the data isn't in one set of rows and some lines may not have values so I'm trying to account for this in my summary.

The code I'm struggling with is this...

=SUMIF(C5,C10,C15,C20,C25,C30,C35,C40,">0")/COUNTIF(C5,C10,C15,C20,C25,C30,C35,C40,">0")

Many thanks for any help...

 

[Domenic]

Dominic: I readily bow to your obvious expertise. Please explain the -ROW(C5). I couldn't see how that helped but you know (I hope) how I love learning.

The formula will still return the desired result if one or more rows are inserted at or prior to Row 5.