View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Castell Castell is offline
external usenet poster
 
Posts: 37
Default 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