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
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