Hi,

In the past I’ve made a box and whisker chart with a reference to a very simple range of numbers, and it’s all worked fine.

This time I want to extract the data from a large table full of information. I’ve got the mean sorted but I can’t quite get the standard deviation and quartiles.

Currently I have =STDEV(IF(Patients[Month]=B202,IF(Patients[Type]="Sev*",Patients[Time to Bloods]))) – but it returns with #Value!.

To run you through what I’m looking for; [Month] is generated from =month(Patients[Arrival]) in the table, all working fine, B202 changes every month to the current month’s number. [Type] is a group of patients, I want all patients in the “Severe Neutropenic” or just “Severe” category. And finally the [Time to Bloods] is the range what I want the STDEV for. I really hope this makes sense!

For the quartiles I have =QUARTILE(IF(Patients[Month]=B202,IF(Patients[Type]="Sev*",Patients[Time to Bloods])),1) – Also returns with #Value!

If anyone could let me know what I’m doing wrong, that would be great!

Thanks,
Brad