I work on excel 2007, but I have worksheets that are shared with people who
have 2003. I have formulas in 2007 and I need to convert them to a 2003
compatible format. I have tried many variations, but I can't get it to work.
Can you help:
Formula # 1:

=COUNTIFS(ADMISSIONS!$I$2:$I$5000,"IN.OTH",ADMISSI ONS!$J$2:$J$5000,'INFO &
STATS'!B12)+COUNTIFS(ADMISSIONS!$I$2:$I$5000,"IN.B C",ADMISSIONS!$J$2:$J$5000,'INFO & STATS'!B12)

Formula # 2:

=COUNTIFS(ADMISSIONS!$B$2:$B$10000,"Y",ADMISSIONS! $I$2:$I$10000,"IN.OTH",ADMISSIONS!$J$2:$J$10000,'I NFO
&
STATS'!B12)+COUNTIFS(ADMISSIONS!$B$2:$B$10000,"Y", ADMISSIONS!$I$2:$I$10000,"IN.BC",ADMISSIONS!$J$2:$ J$10000,'INFO & STATS'!B12)

Thank you!