LinkBack URL
About LinkBacks
Hello.
I have this table:
Week Inventory
746 100
747 80
747 60
747 40
748 100
How can I determaine with a function which is the average inventory in week 747?
/Anders
Hello.
I have this table:
Week Inventory
746 100
747 80
747 60
747 40
748 100
How can I determaine with a function which is the average inventory in week 747?
/Anders
Try
=Sumif(A1:A10,747,B1:B10)/Countif(A1:A10,747)
or
=Average(IF(A1:A10=747,B1:B10)) confirmed with CTRL+SHIFT+ENTER keys not just ENTER
where A1:A10 is the week range and B1:B10 is the Inventory range...adjust to suit your data
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Here's one way:
=AVERAGE(IF((A1:A5=747),B1:B5))
entered as an array formula: Ctrl+Shift+Enter.
Or you could do a pivot table.
Thank you very much!
This helps alot!
/Anders
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks