What do you have in the other cells in column A, i.e. in a2, a3, a4
etc?

If they are empty then you could use the range A1:A21.

Hope this helps.

Pete

On Apr 8, 10:49*am, Bretter99
wrote:
I have a column of data that i want to use SUMIF0 but its not over the whole
range, just every 5th row for instance...

a1=5
a6=8
a11=-5
a16=2
a21=-22

SUMIF only seems to work with a continuous array of cells not targetted
cells, any ideas how to get around this? (I just need to sum the non negative
figures)
something like SUMIF(a1,a6,a11,a16,a21)0 or something like that...

Thanks

Brett