SUMIF of specified cells in a range
Enter the following formula in column B and SUMIF column B:
=IF(MOD(ROW(),5)=0,A1,"")
"Bretter99" wrote in message
...
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
|