Need help with averageif Function

Hello friends

I have a sheet which contains data in particular format:
ColumnA ColumnB ColumnC ColumnN
Oct-12 Department Site1 score
Oct-12 Department Site1 score
Oct-12 Department Site2 score
Oct-12 Department Site4 score

The below formula gives me #NA:

=AVERAGE(IF((MONTH('Data'!$A$2:$A$65535)=10)*(YEAR('Data'!$A$2:$A$65535)=2012),IF('Data'!$B$2:$B$65536="Department",IF('Data'!$C$2:$C$65536="Site",'Data"!$N$2:$N$65536))))


I need the Average of a department for a particular site in the month for oct or sept.


Help would be appreciated.

Originally Posted by FDibbins

2 comments...
1. try using averageif()
2. it doesnt look like you have any actual values in you're sample to average?

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that

I am having problem with this formula as well

=SUMPRODUCT((Data!$C$3:$C$65535="Site")*(Data!$B$3:$B$65535="Department")*(MONTH(Data!A3:A65535="10")*(YEAR(Data!$A$3:$A$65535="2012")*(Data!$N$3:$N$65535))))

The score are different percentage.I am working on 2003 file.