james rockford
Active Member
- Joined
- May 27, 2004
- Messages
- 250
hello to all...well i have a work book and within the work book i have 12 week sheets (listed by months jan to dec ) and one sum sheet....the issue is on the sum sheet ...as i add info to the main work sheets by month i must add the formula to the sum sheet monthly and i would like to add a formula to the sum sheet but when i do i get the divid in the cel....
I.E.work sheet jan cel d7 is where the info sum up to and then i add this info to the sum sheet or =(jan!d7) to copy info over....and would like to do this on all the months by using the if d7=0,"", jan!d7 but does not work
can someone advise the correct formula ...hope this is clear and thanks
I.E.work sheet jan cel d7 is where the info sum up to and then i add this info to the sum sheet or =(jan!d7) to copy info over....and would like to do this on all the months by using the if d7=0,"", jan!d7 but does not work
can someone advise the correct formula ...hope this is clear and thanks