Getting #DIV/0 error in Google Sheets for AVERAGE, SUM, COUNT, etc on column generated by ARRAYFORMULA

by Jesse T.   Last Updated October 09, 2019 20:03 PM

I am trying to get the average value of a column (column C "Profit Margin" in the screenshot) in Google Sheets. For some reason, I get a #DIV/0 error when trying to use any sort of range functions like SUM, AVERAGE, COUNT, etc on this column:

enter image description here

I feel like it is related to the fact that column C was generated using ARRAYFORMULA, but I'm not sure...

Here is a link to a copy of the spreadsheet if you want to look at the data: BuyBack Example Spreadsheet



Related Questions



Adding missing dates to Google Sheets

Updated September 20, 2019 15:03 PM


Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM