Summing formula by date

Discuss the spreadsheet application

Summing formula by date

Postby awascholl » Fri Oct 06, 2017 2:25 am

In the attached spreadsheet, I hope to sum data on the dashboard tab from data in the sales tab.

More detail in the attachment.
Attachments
Sales.ods
(49.48 KiB) Downloaded 25 times
OpenOffice 4.0.0 on Win7
awascholl
 
Posts: 34
Joined: Wed Dec 12, 2012 9:40 pm

Re: Summing formula by date

Postby robleyd » Fri Oct 06, 2017 3:47 am

There are a few things that need more information.

Dates: are the month totals from A required for current year only, a specific year, all years listed?

Sales: C contains positive values which have a corresponding entry in B, positive values which do not have a corresponding entry in B and negative values; which of these are considered sales?
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.4 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1091
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Summing formula by date

Postby Villeroy » Fri Oct 06, 2017 12:46 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24659
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Summing formula by date

Postby awascholl » Fri Oct 06, 2017 5:17 pm

robleyd wrote:There are a few things that need more information.

Dates: are the month totals from A required for current year only, a specific year, all years listed?

This spreadsheet only has current year data, next year will have 2018 data, etc.


Sales: C contains positive values which have a corresponding entry in B, positive values which do not have a corresponding entry in B and negative values; which of these are considered sales?


They're all sales; the negative numbers are refunds. Also, not figures in C have corresponding data in B because that info didn't export from the original database.
OpenOffice 4.0.0 on Win7
awascholl
 
Posts: 34
Joined: Wed Dec 12, 2012 9:40 pm

Re: Summing formula by date

Postby Villeroy » Sat Oct 07, 2017 1:45 pm

t90647.ods
Nother month pivot
(90.64 KiB) Downloaded 23 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24659
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests