Forum Discussion
Median with 2 criteria
Hello, I have been trying to calculate using median IF (and) function as i have two criterias but i keep getting a #value error or a #num area =Median(IF(and(Range=criteria 1, Range = criter...
Hello ! appreciate your response!
Ive tried this however, I received a #Name? issue. I've tried to copy and paste the figures and it was fine.. therefore I'm assuming the format of the cell itself is correct so I'm not sure why theres a name issue. For all the range I have included the name of the Columns and for the criteria i have tried typing with "" and also referencing to a cell but it still doesnt work
Ive tried this however, I received a #Name? issue. I've tried to copy and paste the figures and it was fine.. therefore I'm assuming the format of the cell itself is correct so I'm not sure why theres a name issue. For all the range I have included the name of the Columns and for the criteria i have tried typing with "" and also referencing to a cell but it still doesnt work
Does it work when you enter the sample data from the screenshot in your worksheet? Otherwise can you attach a screenhot of your worksheet without sensitive data which shows all the criteria, range and the formula you've applied?
- Unfortunately still doesnt work. I have tried to alter the data and i realise the formula is just not recognising the numbers. if i enter new numbers e.g. the ones you have screenshot the formula works. however if i use my data it doesnt work. however i have tried general and number formatting.
Perhaps your data are text values that look like numbers.
Try the following:
Select a column with values.
On the Data tab of the ribbon, click Text to Columns.
Click Finish.
Does that make a difference?
