How do I sum the numbers in a column for dates within specific months for certain codes. For example.. from a list of bills, I want to sun the total for food for that month and a separate sum for money spent for fuel, etc. I have column for date, code for item F=food, L for logding, etc.. and a column for amount.
I am using a Mac Air El Capitan, Excel 2011.
Appreciate your assistance.
You can apply a Pivot Table to the data to create a summary on another sheet using any combination of filters you want. Google Pivot Table tutorials, they are numerous and will forever simplify and enhance your reporting of table data forevermore.
_________________
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!)
You can also use sumifs function.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks