I have attached the excel sheet here for reference.
I would like to sum up the values across rows, so long as they have the terms "FQ1", "FQ2", "FQ3" or "FQ4" in the first row.
In other words, for the row "Total Revenue", I would like to sum up the quarterly values, using VBA, since the number of quarters increase with time.
How should I code up a VBA for that?
Thank you for the advice (:
I know you said you wanted VBA for this, but this formula will also give you what you want...
=SUMIF($B$1:$E$1,"FQ*",B10:E10)
I used it on row 10 with data that I entered there. You could add a blank helper column just before your total column, then, when you need to extend your table, insert new columns before the blank column - but include the blank column in the formula
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
Hi Ford!! OMG, IT WORKS!!! Thank you sooooo much!!!! It's brilliant!! And yes I do not need VBA with your formula!! Yay! (: (: (:
Last edited by lch93lily; 08-03-2014 at 10:46 PM.
hehe Im glad we got you were you wanted, and thanks for the feedback
Thank you so much for helping Ford!!! You totally made my weekCheerio!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks