SUMIFS returning #VALUE!

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