The formula at G72 is =SUMIFS(I$7:I$12,E$7:E$12,D72,F$7:F$12,E72,H$7:H$12,"PR")
What I want is for the return at G72 to BE the just the unit price it this case "10.00" and not the overall total of "30.00" so what I have done in this case is to amend the formula to =SUMIFS(I$7:I$12,E$7:E$12,D72,F$7:F$12,E72,H$7:H$12,"PR")/3
Can I change the formula to include a "Divide by count"?
Thanks in advance.
Bookmarks