Hey,
I am having a problem with this formula:
{=MEDIAN(IF(AND('ZEI - RB'!$G$7:$G$5000=B19;'ZEI - RB'!$C$7:$C$5000="CC");'ZEI - RB'!$H$7:$H$5000;""))}
Why doesn't this formula work?
Because this one is very similar and it works:
{=MEDIAN(IF('ZEI - RB'!$G$7:$G$5000=B19;'ZEI - RB'!$H$7:$H$5000;""))}
Could you help me?
Many Thanks!
In array formula's * operates as AND operator
=MEDIAN(IF(('ZEI - RB'!$G$7:$G$5000=B19)*('ZEI - RB'!$C$7:$C$5000="CC");'ZEI - RB'!$H$7:$H$5000))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks