jerrymoon1
Board Regular
- Joined
- Nov 15, 2006
- Messages
- 139
Hi,
I have a spreadsheet where a 12 month trend is displayed and I calculate the average of the previous 3 months and previous 11 month averages (ignoring the current month of the trend). The 3 month trend is in column Q and the 11 month trend is in column R. When I copy the formula down, I sometimes get a 0 (because of a blank row) or a Div/0 error (due to having lines in the data both ---- and =====) and I would rather have the formula display a blank in these situations. How would I be able to accomplish this? Here are examples of my formula:
Cell Q16 =average(J16:L16)
Cell R16 =average(B16:L16)
Thanks for any help!!
I have a spreadsheet where a 12 month trend is displayed and I calculate the average of the previous 3 months and previous 11 month averages (ignoring the current month of the trend). The 3 month trend is in column Q and the 11 month trend is in column R. When I copy the formula down, I sometimes get a 0 (because of a blank row) or a Div/0 error (due to having lines in the data both ---- and =====) and I would rather have the formula display a blank in these situations. How would I be able to accomplish this? Here are examples of my formula:
Cell Q16 =average(J16:L16)
Cell R16 =average(B16:L16)
Thanks for any help!!