Averageif Too many arguments

[pgford]

Hi all,
I'm new to posting here an not much of a wizard with Excel formulas, so was hoping someone would be able to help please.
I'm trying to calculate an average percentage from another workbook, for anything that's 8% or higher.

Here is my formula =AVERAGEIF('[Sample Spreadsheet.xlsx]JAN'!$D$14:$D$163,"Name",'[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,"<8")
When using this formula, it's telling me I've entered too many arguments. Is there a different way I could do this? Perhaps a different function?

Any help with this would be much appreciated.

Thanks,
Paul

 

[AlphaFrog]

Looks like you have more than one criteria; "Name" and >8%
Try using the AVERAGEIFS function

=AVERAGEIFS('[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,
'[Sample Spreadsheet.xlsx]JAN'!$D$14:$D$163,"Name",
'[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,">"&0.08)

 

[pgford]

AlfaFrog - thank you so much for your help - that worked perfectly.

 

[pgford]

Hi Alpha, hoping you can help me once again here
I've finished adding this formula, however some of the responses are coming back with DIV/0! because some of the cells don't have enough data in them as yet (but will in time).
Is there something I can do to get rid of #DIV/0! ? As I'm wanting to use =AVERAGE(W3:W6) where currently W5 is displaying #DIV/0! so I'm getting an error with the next stage.

 

[AlphaFrog]

Wrap the formulas in an IFERROR function...

=IFERROR(your formula, "")

 

[pgford]

Thanks Alpha, I just tried it as below and it comes back with the too many arguments error again...
=IFERROR(AVERAGEIFS('[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,
'[Sample Spreadsheet.xlsx]JAN'!$D$14:$D$163,"Name",
'[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,">"&0.08,"")

=IFERROR('[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,
'[Sample Spreadsheet.xlsx]JAN'!$D$14:$D$163,"Name",
'[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,">"&0.08,"")

I must be missing something

 

[AlphaFrog]

=IFERROR(AVERAGEIFS('[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,
'[Sample Spreadsheet.xlsx]JAN'!$D$14:$D$163,"Name",
'[Sample Spreadsheet.xlsx]JAN'!$T$14:$T$163,">"&0.08),"")

 

[pgford]

Thank you - that's worked perfectly.