Excel : How to do

Here is what I am trying to achieve,

In sheet 1 column C  have value which are month and year (Jan-2015), now in adjacent  column D I have a value in $ (15000,00).

In sheet 2 I Need A1 to give me the sum of all value in column D with the adjacent value being (Jan-2015) and so on.
Eric SaccoiaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You don't need a formula to get that summary. A pivot table can automatically create such summary for you.

Insert a Pivot Table, drag the Month and Year Field into the Row Area and drag the Value into the Values Area, and you will have instant summary one like you want to have.

If you don't know how to insert a Pivot Table, just read about it and if unable to insert it own, please upload a small sample workbook, I can help you in creating such summary.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eric SaccoiaAuthor Commented:
Much easier than anticipated, Thanks a lot I didn't know about pivot table but it worked like a charm. A+
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
As far as the formula is concerned, you may use SUMIF for that purpose.

On Sheet2, list all your unique months in col. A starting from A2, where A1 being the header Month.
In B1, input Total.

Now in B2 use the SUMIF formula like this.....

=SUMIF(Sheet1!<your month range in sheet1 e.g. C2:C100>,A2,Sheet1!<your value range on Sheet1, say D2:D100)

Remember to make both the referenced range symmetrical in size.
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Eric!
Glad you found the solution helpful. :)
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
A Tip:

Convert your data on Sheet1 into a Excel Table by selecting a cell inside the data set and press Ctrl+T and that will convert your data set to an excel table.
Now insert your pivot table based on your table. The advantage of this is, whenever you add new data on Sheet1, just go to Sheet2 where you have inserted the pivot table, right click inside the pivot table and select Refresh, and your pivot table will reflect the new data which you added on Sheet1.

Helpful?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.