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