sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I'm trying to get the median from a range of values with 2 conditions - this formula is producing a #NUM error but I don't understand why if anyone can help?
"=MEDIAN(IF(DATA!$I$2:$I$2338=L$4,IF(DATA!$D$2:$D$2338=K5,DATA!$H$2:$H$2338)))"
For info, here's a snapshot of the data range;
In the formula, L4 = Monday and K5 = 0-1, (there are multiple examples in the data range that match that criteria).
I'm trying to get the median from a range of values with 2 conditions - this formula is producing a #NUM error but I don't understand why if anyone can help?
"=MEDIAN(IF(DATA!$I$2:$I$2338=L$4,IF(DATA!$D$2:$D$2338=K5,DATA!$H$2:$H$2338)))"
For info, here's a snapshot of the data range;
Booking In Time | Day | Hour |
334 | Sunday | 15-16 |
334 | Tuesday | 6-7 |
315 | Tuesday | 18-19 |
313 | Thursday | 18-19 |
301 | Tuesday | 15-16 |
285 | Tuesday | 16-17 |
255 | Thursday | 17-18 |
251 | Friday | 11-12 |
246 | Thursday | 22-23 |
229 | Tuesday | 11-12 |
226 | Thursday | 15-16 |
225 | Thursday | 19-20 |
224 | Thursday | 18-19 |
221 | Friday | 19-20 |
220 | Wednesday | 23-24 |
219 | Wednesday | 17-18 |
214 | Thursday | 22-23 |
213 | Friday | 11-12 |
In the formula, L4 = Monday and K5 = 0-1, (there are multiple examples in the data range that match that criteria).