Hey Hey,

Some how I'm tangled up in a work project and I could use some help with a
formula. We are trying to "count" each supervisors "safe" and "unsafe"
actions based on a date range.

Sheet in question is called "summary". A3 & B3 = date range, C6 & C7 are
where the forumlas are places. We have this working in Excel 2007, but it
DOESN'T work in 2003 and it needs to work in 2003. I get a bunch of errors
within the forumla.

If anyone could help make this 03 compatible, I would REALLY appreciate it.
:-)

C6 Formula:
=(COUNTIFS('D. Warner'!A:A,"<"&$B$3+1,'D. Warner'!A:A,""&$A$3-1,'D.
Warner'!D:D,"Safe"))+(COUNTIFS('P. Winkler'!A:A,"<"&$B$3+1,'P.
Winkler'!A:A,""&$A$3-1,'P. Winkler'!D:D,"Safe"))+(COUNTIFS('R.
Freeman'!A:A,"<"&$B$3+1,'R. Freeman'!A:A,""&$A$3-1,'R.
Freeman'!D:D,"Safe"))+(COUNTIFS('M. Pfeifer'!A:A,"<"&$B$3+1,'M.
Pfeifer'!A:A,""&$A$3-1,'M. Pfeifer'!D:D,"Safe"))+(COUNTIFS('T.
McCanna'!A:A,"<"&$B$3+1,'T. McCanna'!A:A,""&$A$3-1,'T.
McCanna'!D:D,"Safe"))+(COUNTIFS('N. Rasmussen'!A:A,"<"&$B$3+1,'N.
Rasmussen'!A:A,""&$A$3-1,'N. Rasmussen'!D:D,"Safe"))+(COUNTIFS('M.
Parra'!A:A,"<"&$B$3+1,'M. Parra'!A:A,""&$A$3-1,'M.
Parra'!D:D,"Safe"))+(COUNTIFS('M. Kieser'!A:A,"<"&$B$3+1,'M.
Kieser'!A:A,""&$A$3-1,'M. Kieser'!D:D,"Safe"))+(COUNTIFS('B.
Scheppler'!A:A,"<"&$B$3+1,'B. Scheppler'!A:A,""&$A$3-1,'B.
Scheppler'!D:D,"Safe"))

C7 Forumla:
=(COUNTIFS('D. Warner'!A:A,"<"&$B$3+1,'D. Warner'!A:A,""&$A$3-1,'D.
Warner'!D:D,"Unsafe"))+(COUNTIFS('P. Winkler'!A:A,"<"&$B$3+1,'P.
Winkler'!A:A,""&$A$3-1,'P. Winkler'!D:D,"Unsafe"))+(COUNTIFS('R.
Freeman'!A:A,"<"&$B$3+1,'R. Freeman'!A:A,""&$A$3-1,'R.
Freeman'!D:D,"Unsafe"))+(COUNTIFS('M. Pfeifer'!A:A,"<"&$B$3+1,'M.
Pfeifer'!A:A,""&$A$3-1,'M. Pfeifer'!D:D,"Unsafe"))+(COUNTIFS('T.
McCanna'!A:A,"<"&$B$3+1,'T. McCanna'!A:A,""&$A$3-1,'T.
McCanna'!D:D,"Unsafe"))+(COUNTIFS('N. Rasmussen'!A:A,"<"&$B$3+1,'N.
Rasmussen'!A:A,""&$A$3-1,'N. Rasmussen'!D:D,"Unsafe"))+(COUNTIFS('M.
Parra'!A:A,"<"&$B$3+1,'M. Parra'!A:A,""&$A$3-1,'M.
Parra'!D:D,"Unsafe"))+(COUNTIFS('M. Kieser'!A:A,"<"&$B$3+1,'M.
Kieser'!A:A,""&$A$3-1,'M. Kieser'!D:D,"Unsafe"))+(COUNTIFS('B.
Scheppler'!A:A,"<"&$B$3+1,'B. Scheppler'!A:A,""&$A$3-1,'B.
Scheppler'!D:D,"Unsafe"))

Example sheet: http://rockee.endlessobsessions.com/test/Pillars.zip