Forum Discussion
Complex formulae with data model
Over the years, I have developed a significant excel data sheet which has gotten slower and slower with time. I have discovered the idea of excel's data model this week and have learnt how to impor...
The formula should read...sorry.
=IF(COUNTIF(B5:M5,">0"),SUM(Patient!B5:M5*0),Patient!N5)