Howdy, im trying to figure out how a spread sheet works that a former employee left on his computer. It has 13 sheets, one sheet for every month and a grand total sheet that includes every line for each sheet. It seems to work great except that it stops totaling after april
for example:
January Sheet:
Order# Contact
101 Bob
102 Joe
103 Jim
Feburary Sheet:
Order# Contact
104 john
105 jill
106 ed
March Sheet:
Order# Contact
107 sam
108 jojo
109 bill
Etc....
Total Sheet:
Order# Contact
101 Bob
102 Joe
103 Jim
104 john
105 jill
106 ed
107 sam
108 jojo
109 bill
It does this but stops for some reason at the april sheet, heres whats in the formula bar for the rows in the grand total sheet:
=IF(April!A17=0,"",April!A17)
for example:
January Sheet:
Order# Contact
101 Bob
102 Joe
103 Jim
Feburary Sheet:
Order# Contact
104 john
105 jill
106 ed
March Sheet:
Order# Contact
107 sam
108 jojo
109 bill
Etc....
Total Sheet:
Order# Contact
101 Bob
102 Joe
103 Jim
104 john
105 jill
106 ed
107 sam
108 jojo
109 bill
It does this but stops for some reason at the april sheet, heres whats in the formula bar for the rows in the grand total sheet:
=IF(April!A17=0,"",April!A17)