I need a automatic monthly percentage equation for the following vendors. I need an equation formula that goes by month (Row 2) so I don't have to keep updating it every month.
Please see attached.
Thank you!
I need a automatic monthly percentage equation for the following vendors. I need an equation formula that goes by month (Row 2) so I don't have to keep updating it every month.
Please see attached.
Thank you!
Last edited by neelpatel; 07-31-2012 at 03:05 PM.
Is this what you are looking for? Don't have your spreadsheets horizontally oriented, it makes it hard to read and hard to fill out formulas...
Book1(1).xlsx
Hi
what is a monthly percentage equation in your understanding?
thank you brandonlaw! but i was hoping it could be in 3 cells only and by the month it would update itself
See attached...
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you ace_xl and brandonlaw! I appreciate it!
Ace's works. Mine is a different take in that it updates based on today's date.
=OFFSET(A3,0,MATCH(EOMONTH(NOW(),-1)+1,$B$2:$L$2,0))/SUM(OFFSET($A$3,0,MATCH(EOMONTH(NOW(),-1)+1,$B$2:$L$2,0),3,1))
Then drag down two more cells to get the other two companies.
Pauley
You are the man Pauleyb! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks