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.
may be
=SUMIFS(I$7:I$12,E$7:E$12,D72,F$7:F$12,E72,H$7:H$12,"PR")/countifs(E$7:E$12,D72,F$7:F$12,E72,H$7:H$12,"PR")
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks