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