Hi All

I have 4 sheetsthat I use the following formula

=COUNTIF(B8:K37, "=0") - COUNTIF(B8:K37,"=42")

to check if the data entered meets the criteria in the formula

I want to use this formula in another sheet called "Totals"
How do I link this formula to the other 4 sheets to pull the data from those
sheets
The formula above works great in the separate sheets.

The other sheet names are A CREW B CREW C CREW D CREW

Thanks for5 the help


--
crunchin numbers