Hello,
Please see the attached. I would like to know why the sumifs formuale is not working....it was working on another copy....
The idea here is to calculate the mean in col F in "new CCM clinic reporting" worksheet.
I am using a named range as well, but it's just not working...
Formula I used is:
=ROUND((SUMIFS(VGHClinicMean,VGHClinicRP,$B2,VGHClinicSite,$E2)+SUMIFS(LGHClinicMean,LGHClinicRP,$B2,LGHClinicSite,$E2))/MAX(1,COUNTIFS(VGHClinicRP,$B2,VGHClinicSite,$E2)+COUNTIFS(LGHClinicRP,$B2,LGHClinicSite,$E2)),2)
Could anybody help please?
Thank you
Bookmarks