Median function not working

A

Alex

I can write a conditional count function for a given
dataset, but if I use the same input, it won't give me a
conditional median.

For example,
{=COUNT(IF((A$1:A$5="AZ")*(B$1:B$5=3),C$1:C$5))} 3
{=MEDIAN(IF((A$1:A$5="AZ")*(B$1:B$5=3),C$1:C$5))} #N/A

I have tried other functions like max, sum, and min. Only
count works with this dataset.

Do you have suggestions to what the problem might be?

Thanks
Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top