alloakland1
New Member
- Joined
- Dec 9, 2013
- Messages
- 19
Hi, I have the following array formula, but it is not working. Any ideas would be much appreciated!
I press crtl,shift,enter but a #NUM error shows up.
=MEDIAN(IF('Sheet2'!A1:A5000=(CONCATENATE(a1,d2)),'Sheet3'!$BF1:$BF5000))/60
I press crtl,shift,enter but a #NUM error shows up.
=MEDIAN(IF('Sheet2'!A1:A5000=(CONCATENATE(a1,d2)),'Sheet3'!$BF1:$BF5000))/60