hello all,
I was given a helpful formula
=IFERROR(VLOOKUP(A3,$B$6:$D$9,3,0),"")
It works, but for a very limited amount. It will only add each from Col B once. I will be adding to this excel as the fiscal month carries on. I attempted to change $B$6:$D$9 to $B$6:$D$150 to cover a certain area of the spreadsheet,but it doesnt work.BudgetTracker2012.xlsx
I hope this makes sense.
I think you're using the wrong function... Use a SUMIF and just include a large enough starting range as to not have to worry?
=SUMIF($B$6:$B$10000, B$3, $D$6:$D$10000)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Bad thing is I am new at excel, good thing is your formula worked perfect. Thanks for the help.
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks