Hello, I have written a formula to calculate the average values in column AE (based on several other conditions), as per the following:
=SUM(SUMIFS(AE:AE,AA:AA,"Arabica Shift",AB:AB,">0",AD:AD,">0",F:F,"No"))/SUM(COUNTIFS(AA:AA,"Arabica Shift",AB:AB,">0",AD:AD,">0",F:F,"No",D:D,"1"))
At the moment I am getting an error message but I can't spot my mistake....is anybody able to help, please? Do you need to know what all the other column references?
I am trying to calculate the average value in column AE if.... AA=Arabica Shift, AB>0, AD>0, F="No", D="1"
Many Thanks
Bookmarks