Thread
: [Solved]
Table with values from several locations and years - need to find comp values
View Single Post
06-08-2018, 01:20 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
As it looks like you have defined a Table, and assuming for a location you have not more than 1 row on same day (on fly):
Code:
=SUMIFS([Ext. Price],[Name],[@Name],[day week],[@[day week]],[week],[@week],[year],[@year]-1)
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets