Tricky ISBLANK - please help!

[Ross Taylor]

Hi All,

I have built a spreadsheet which will hopefully show MEDIAN and MEAN based on selections in dropboxes.

I want my formulas to ignore the references in the dropboxes if they are blank. I know I will probably need to use ISBLANK but I am not sure where to put them. My mean formula is this:

=AVERAGE(IF(Data!$L:$L=Mean!$C$4,IF(Data!$M:$M=Mean!$E$4,
IF(Data!$E:$E=Mean!$G$4,IF(Data!$AB:$AB=Mean!$I$4,Data!$P:$P)))))

Could anyone please point me in the right direction?

Thanks,

Ross.

 

[mole999]

couple of things
Median and Average obviously are going to be at logger heads

If you have 2010 and up you might like Aggregate AGGREGATE Function option 4 allows the function to ignore nulls