In the attached example, I would like to take the average of the numer of units in row 5 based on the criteria in row 7.
So I want to take the last dat in column CF and take the average last 8 weeks of units based but only if the is a "RP" in row 7.
Not sure how to go about doing this with an averageif statement.
Thanks!
hmm you know, if you are going to post duplicate threads, the least you could do is correct your spelling!!!!
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-form...-criteria.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks