mcooer0913
New Member
- Joined
- Feb 16, 2009
- Messages
- 22
I'm using a user-defined function, MEDIANIF, which has the same syntax as AVERAGEIF. I need to find the median of a range of cells (column A) if the value next to it in column B reads "Assessment".
My problem, though, is that the value in column B is derived from a VLOOKUP formula, so the MEDIANIF function returns "VALUE!".
Is there a way to have the cells in column B be read as text and not as their underlying formulas? Or does anyone have a better way to go about this?
Thanks.
Matt
My problem, though, is that the value in column B is derived from a VLOOKUP formula, so the MEDIANIF function returns "VALUE!".
Is there a way to have the cells in column B be read as text and not as their underlying formulas? Or does anyone have a better way to go about this?
Thanks.
Matt