Div/0 Error with average

Aixaix

New Member
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!

Joe4

=AVERAGE(B2:B39)
=AVERAGE(C2:C39)
Wrap each one in IFERROR, like we both told you.

=IFERROR(AVERAGE(B2:B39),"")
=IFERROR(AVERAGE(C2:C39),"")

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Replies
5
Views
447
Replies
1
Views
169
Replies
7
Views
404
Replies
2
Views
613
Replies
0
Views
288

1,128,161
Messages
5,629,050
Members
416,363
Latest member
zaveedd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back