Hello,
I need a formula that pulls the total of every Jan 1-2018 volume but everything I've googled hasn't resulted in anything.
In column D, I have daily dates from Jan 1 2018 to Dec 31 2018 for a bunch of locations.
I need to find the total for everything that equals Jan 1 2018, Jan 2 2018, Jan 3 2018, etc.
Help.JPG
Is this possible?
SOmehow I can't attach the excel spreadsheet. Hopefully you can see the picture....
Sorry!
Well, I’d think you could use SUMIF, SUMIFS, or even SUMPRODUCT to give the result you want.
Maybe even insert a Pivot Table and filter for the dates you are interested in.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I tried =SUMIF(D4:D6938,"*43101*",G4:G6938) and I'm getting 0s back. I changed the dates to text too.
Try this:
Does that give you the results you're looking for?
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
The pivot table worked perfectly. Thank you for the help!!!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks