# Need help with averageif Function

1. ## 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.

2. ## Re: Need help with averageif Function

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

3. ## Re: Need help with averageif Function

Originally Posted by FDibbins
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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1