error message when entering array formula

[ariel20029]

Hi,
I am trying to write an array formula for median if statement.

=median(if(A25:A223="End Customer")*(A25:A223="Partner"),G25:G223)) the hit control shift enter..for the array

excel keep popping up there is a problem with this formula .. not trying to enter a formula.. (

I tried retyping and reentering the formula with no luck. I even tried making end customer and Partner individual cells and reference the cells instead of words that did not help.




Can anyone let me know how to fix this?
thanks,
Sharon

 

[Marcelo Branco]

I can see two issues in your formula
1. Syntax
A parenthesis is missing before A25
2. Logic
Multiplying the two conditions is equivalent to an AND condition. How can a cell be equal to "End Customer" and "Partner" at the same time?

I think you want equal to "End Customer" OR equal to "Partner". If so, you must add the two conditions, ie
=median(if((A25:A223="End Customer")+(A25:A223="Partner"),G25:G223))
Ctrl+Shift+Enter

M.

 

[kweaver]

A25:A223 can't be both End Customer and Partner. That's what the * will do. If you want it to be OR, then use +.

 

[ariel20029]

Hi all,
the formula was from a video on YouTube that said the * acted like an OR statement I will try the changes.. thank you so much for your feedback!!!
Have a great day.Sharon

 

[ariel20029]

Thank you so much making those 2 changes worked!!!! I went back and rewatched the video and it was for an and statement not an Or statement.. Thank you so much for helping me out and helping me learn more.

Sharon

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.