hello all,
I am trying to averageif a few values (time1 or time2 in the excel file attached) based on their dates criteria thus getting average values for jan, feb,march and so on
WHAT IF THE year is 2013, instead on 2012 (since only year value will be changing in the formula not the months) can I put a variable cell reference or a Macro ?? If it's a macro then I have no clue lol. Any help in regards to that please.
with 2 helpcolumns and a pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you so much for your solution. i was wondering is theres a way a to do it through a macro ?
Why will you use a macro for that.
It can (easily) done without.
Though I need to learn Pivots too so i Guess thats fine!
Got the answer from
http://www.excelforum.com/excel-gene...ou-please.html
Glad you found your answer yourself.
but for this one, i'm sure you get easier an result with pivot table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks