Timeline for Getting #DIV/0 error in Google Sheets for AVERAGE, SUM, COUNT, etc on column generated by ARRAYFORMULA
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 10, 2019 at 22:55 | history | edited | marikamitsos | CC BY-SA 4.0 |
Edit (following OP's sharing the sheet)
|
| Oct 10, 2019 at 18:15 | comment | added | Jesse T. | Sorry, I copied from the original document because I can't share it since it has private -customer data in it. The data is not formatted as text. It was formatted as number (I also tried converting it to %) Neither worked. The $ fields are also numeric, not text btw. | |
| Oct 10, 2019 at 5:11 | history | edited | marikamitsos | CC BY-SA 4.0 |
added 182 characters in body
|
| Oct 10, 2019 at 5:01 | history | answered | marikamitsos | CC BY-SA 4.0 |