Thread: Adding in increments
View Single Post
  #7  
Old 01-26-2007, 09:53 AM
steven21 steven21 is offline
Registered User
  
Join Date: 25 Jan 2007
Posts: 4
steven21 is an unknown quantity at this point
I have deleted the blank columns but I am still not sure if its correct - for example I know cell G32 should be 2, but its showing 0.

=SUMPRODUCT(--(MOD(COLUMN(J5:IO5)-COLUMN(J5),5)=0),J5:IO5)

is the formula
Attached Files
File Type: zip Revised Stats.zip (99.7 KB, 26 views)
Reply With Quote