Good afternoon!
I am trying to get an excel formula to function correctly. I currently have 3 rows of numbers per salesperson that average at the bottom of each row. I am then trying to average the rows for every 3rd row into another cell so if I remove a salesperson I want to see what the average would increase or decrease. The issue is not every salesperson has data in each row so its throwing out the div/0 error. I have attempted several different formulas to see if I can get it it working but some still give the div/0 and some return no data.
=IFERROR(AVERAGE(B40,E40,H40,K40,N40,Q40,T40,W40,Z40,AC40,AF40,aj40i40,AI40,AL40,AO40,AR40,AU40,AX40),"")
=AVERAGE(B40,E40,H40,K40,N40,Q40,T40,W40,Z40,AC40,AF40,AJ40,I40,AI40,AL40,AO40,AR40,AU40,AX40)
Any help would be great. Thank you!
I am trying to get an excel formula to function correctly. I currently have 3 rows of numbers per salesperson that average at the bottom of each row. I am then trying to average the rows for every 3rd row into another cell so if I remove a salesperson I want to see what the average would increase or decrease. The issue is not every salesperson has data in each row so its throwing out the div/0 error. I have attempted several different formulas to see if I can get it it working but some still give the div/0 and some return no data.
=IFERROR(AVERAGE(B40,E40,H40,K40,N40,Q40,T40,W40,Z40,AC40,AF40,aj40i40,AI40,AL40,AO40,AR40,AU40,AX40),"")
=AVERAGE(B40,E40,H40,K40,N40,Q40,T40,W40,Z40,AC40,AF40,AJ40,I40,AI40,AL40,AO40,AR40,AU40,AX40)
Any help would be great. Thank you!