LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hello,
I am using this formular to find the average for a certain products but it comes back with a DIV/0!. I still want the formular to be in the back ground as when i rerun the report it may come back with a figure.
This is the current formular i am using:
{=AVERAGE(IF($J$20:$J$201=B5,$AI$20:$AJ$201))}
Hope you can help.
Many thanks
Lauren
I am using this formular to find the average for a certain products but it comes back with a DIV/0!. I still want the formular to be in the back ground as when i rerun the report it may come back with a figure.
This is the current formular i am using:
{=AVERAGE(IF($J$20:$J$201=B5,$AI$20:$AJ$201))}
Hope you can help.
Many thanks
Lauren