View Single Post
  #9  
Old 01-26-2007, 10:33 AM
daddylonglegs's Avatar
daddylonglegs daddylonglegs is offline
Forum Moderator
 
Join Date: 14 Jan 2006
Location: England
Posts: 5,166
daddylonglegs is a jewel in the rough
Rather than trying to sum every 5th column it should be easier to use SUMIF based on your column headers

I’m not sure exactly which formulas you’re referring to but try this formula in C5 on u19’s worksheet

=SUMIF($I$4:$IO$4,C$4,$I5:$IO5)

copy across to column G and then down
Reply With Quote