Hello,
I'm using AVERAGEIFS and an array formula to retrieve average and std deviation based on a few criteria. I'm getting an error in the array and i cant seem to figure out why. File attached
Hello,
I'm using AVERAGEIFS and an array formula to retrieve average and std deviation based on a few criteria. I'm getting an error in the array and i cant seem to figure out why. File attached
In the array formula, all the conditions are false but no alternative exists.
This will, at least, render a zero result:
Formula:Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I figured it out. It was the condition Line=$F$26.
In my table numbers were stored as text for some reason, leading to the condition being false.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks