| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
applying COUNTIF formula across several sheets
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| applying formulas for all sheets selected | Excel Worksheet Functions | |||
| Applying J-Walk's SheetOffset() to SUM across sheets - possible? | Excel Worksheet Functions | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| applying formula | Excel Discussion (Misc queries) | |||
| Applying colour to my Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
