Hi,
I need help finding the average of a large data set. Attached is a sample. I'd like to find the average amount of Sales for Store 1, Store 2, Store 3, and Store 4. I know I can simply use the AVG equation, but the actual data set contain hundreds of stores.
Can anyone help me build a formula that will take the average amount per store?
Thanks for the help!
-Andy
=AVERAGEIF($A$2:$A$14,D3,$B$2:$B$14)
Drag accross
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Andy in D4 and copy across, try this.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks