Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hoping someone can help, completely stumped what issue is
Trying to apply this formula to a sharepoint excel file , where I've moved the "Raw Data" file to another sharepoint location , but getting a different result "-" instead of a value from the original spreadsheet , not sure error ( no errors displayed) or that the formula doesn't work on sharepoint files
Original formula from Overview Worksheet which contains summary of all colleagues performance ( quality ) Period 1 - Period 12 taken from "Raw Data" Worksheet ( Column CF contains Quality data for each call for all periods and Column A contains colleague names & Period number e.g. John SmithP1, "Overview " worksheet contains the average data for each colleague with column A containing colleague names and Columns B - Column M contains Period numbers e.g. P1...P2..P3...P4....P12
=IFERROR(AVERAGEIFS('Raw Data'!$CF$4:$CF$500,'Raw Data'!$A$4:$A$500,Overview!$A$5&Overview!$B$4),"-")
Formula/Result in Column B5 = 85 ( average 90,90,75)
Sharepoint File Test QM 2022-2023.xlsx, "Team Overview" Worksheet contains the average data for each colleague with column A containing colleague names and Columns B - Column M contains Period numbers e.g. P1...P2..P3...P4....P12 and "Raw Data" is on "Raw Data" Worksheet on QM Raw Data File 2022-23.xlsx
Formula/Result is in B5 should be 85 but displaying "-"
=IFERROR(AVERAGEIFS('https://xxxx-my.sharepoint.com/personal/xxx/Documents/My Team Files/My Team Period QM/[QM Raw Data File 2022-23.xlsx]Raw Data'!$CF$4:$CF$500,'https://xxxx-my.sharepoint.com/personal/xxx/Documents/My Team Files/My Team Period QM/[QM Raw Data File 2022-23.xlsx]Raw Data'!$A$4:$A$500,Team Overview!$A$5&Team Overview!$B$4),"-")
Trying to apply this formula to a sharepoint excel file , where I've moved the "Raw Data" file to another sharepoint location , but getting a different result "-" instead of a value from the original spreadsheet , not sure error ( no errors displayed) or that the formula doesn't work on sharepoint files
Original formula from Overview Worksheet which contains summary of all colleagues performance ( quality ) Period 1 - Period 12 taken from "Raw Data" Worksheet ( Column CF contains Quality data for each call for all periods and Column A contains colleague names & Period number e.g. John SmithP1, "Overview " worksheet contains the average data for each colleague with column A containing colleague names and Columns B - Column M contains Period numbers e.g. P1...P2..P3...P4....P12
=IFERROR(AVERAGEIFS('Raw Data'!$CF$4:$CF$500,'Raw Data'!$A$4:$A$500,Overview!$A$5&Overview!$B$4),"-")
Formula/Result in Column B5 = 85 ( average 90,90,75)
Sharepoint File Test QM 2022-2023.xlsx, "Team Overview" Worksheet contains the average data for each colleague with column A containing colleague names and Columns B - Column M contains Period numbers e.g. P1...P2..P3...P4....P12 and "Raw Data" is on "Raw Data" Worksheet on QM Raw Data File 2022-23.xlsx
Formula/Result is in B5 should be 85 but displaying "-"
=IFERROR(AVERAGEIFS('https://xxxx-my.sharepoint.com/personal/xxx/Documents/My Team Files/My Team Period QM/[QM Raw Data File 2022-23.xlsx]Raw Data'!$CF$4:$CF$500,'https://xxxx-my.sharepoint.com/personal/xxx/Documents/My Team Files/My Team Period QM/[QM Raw Data File 2022-23.xlsx]Raw Data'!$A$4:$A$500,Team Overview!$A$5&Team Overview!$B$4),"-")
