Summing by groups
I have attached a sample of a form I use to pay contract drivers when we use them, so they have a copy of what they are getting paid for and I can apply the charges to the correct group in Quickbooks.
My problem is that I want to keep the form in date order but I need the sum of each group's charges and they are not consecutive. What is the best way to do this so I don't have to do +++++++ forrevvvvver.
Any help appreciated. Would love to have this solved before my next snorkel date
Try this in C48
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
Move your TOTALS out of the data columns. Then simple SUMIF formulas will give you your totals.
_________________
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!)
Hi,
Try using the SUMIF formula. It allows you to add cells specified by a given criteria. =SUMIF(C2:C46,"Company A",D2:D46) - sums the amounts entered that correspond to the group you've selected, in this case company A. I've attached the file so you can see if this is what you're looking for. Hope this helps
Both of these are great and have solved my problem! Thank you so much.. I am think LMunoz gets Kudos and a Special Splash for the simplest solution but thanks to both of you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks