Thread: Table with values from several locations and years - need to find comp values
View Single Post
 
Old 06-26-2018, 01:52 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
An interesting problem.
To clarify things and make things easier for us, could you supply a file with some data, also, could you set up the table that you show in Image 2 in the file and manually calculate the values you expect to see there Using the data you supply)? In addition, could you put a comment in those cells with sales amounts showing the 2 dates you have used for the Sum in each case?
Reply With Quote