I am on the last question of my assignment but I am having difficulty....
It states:
Go to the summary worksheet. and then enter appropriate functions in the range B5:C7 to determine the average modem price and count for each modem price...
I have figured out the count part of this, but not the price...
I assume I would use AVERAGEIF?
I don't understand how to use AVERAGEIF
ANy help is appreciated! :-)
Hiya, you are right. Averageif will certainley answer your question.
=AVERAGEIF(range, criteria, [average_range])
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Whenever I try AVERAGEIF, I get an error
This is what I put in
=AVERAGEIF(ProductPrice[Price],A5)
What would I put in for Range, Criteria, and Average Range?
Your help is appreciated!
Last edited by abbycat02; 09-22-2012 at 02:09 PM.
the answer is above.
The formula consits of 3 factors Range, criteria, and average range. how many factors has your formula taken into consideration?
We dont do homework on EF, but simply point in the right direction. If you google Avgif.... you will be fine.
Excel Help explains it . . . press the F1 key.I don't understand how to use AVERAGEIF
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
PC Modem2Shadrack.xlsx
View this. Report if your problem is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks