ExcelRookie57
New Member
- Joined
- Apr 3, 2019
- Messages
- 2
Good Morning,
I need help getting an excel formula working.
This is the formula I'm using: =IFERROR(AVERAGEIFS('Master SKU Tracker'!$E$2:$E$3922,'Master SKU Tracker'!$B$2:$B$3922,Scorecard!$B5,'Master SKU Tracker'!$C$2:$C$3922,Scorecard!$L$1),"")
This formula is working perfectly for the other B cells: Scorecard!$B6-10 cells but not B5.
Right now it populates 0, if I copy and paste the formula from B6 it populates that value (11) even though it's pulling cell B5 which should be 45.
But, when I right click and hover over paste 'Formulas (f)' it shows the 45 that is supposed to be there but after I click paste it just puts 11 in there, the value of B6.
Any help would be appreciated.
I need help getting an excel formula working.
This is the formula I'm using: =IFERROR(AVERAGEIFS('Master SKU Tracker'!$E$2:$E$3922,'Master SKU Tracker'!$B$2:$B$3922,Scorecard!$B5,'Master SKU Tracker'!$C$2:$C$3922,Scorecard!$L$1),"")
This formula is working perfectly for the other B cells: Scorecard!$B6-10 cells but not B5.
Right now it populates 0, if I copy and paste the formula from B6 it populates that value (11) even though it's pulling cell B5 which should be 45.
But, when I right click and hover over paste 'Formulas (f)' it shows the 45 that is supposed to be there but after I click paste it just puts 11 in there, the value of B6.
Any help would be appreciated.