hi all

i am currently using excell 2011 at home however 2003 verison at work, i have done a spreadsheet that checks a column on the other sheet for a letter and then in tern counts up another column. the formula is =COUNTIFS('3 RIFLES DVR DATABASE'!$E$10:$E$528,"A",'3 RIFLES DVR DATABASE'!$I$10:$I$528,"<>")

however when i open the spreasheet up in 2003 version i get a #NAME? error. does anyone have an idea on how i change the formula to get it to work or have a different formula i can try

thank you

mick