You would put the formulas wherever you want the answers at. Sounds to me
like you would want calculations on each of the different crews sheets, then
put that total info on one main sheet.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"PATRICIA-D-BOS" wrote in message
...
i have a data sheet showing production schedules for different types of
Crews.
i want to build formulas that will calculate the daily production of the
crews in different sheets. would i put my formulas in my data sheet or in
the
Crew sheets.