|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#4
06-08-2018, 01:20 PM
|
|||
|
|||
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) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find matching values between 2 docs | sam1234 | Word | 3 | 11-27-2017 04:05 PM |
| code to find account and sum up values | Brian13 | Excel Programming | 2 | 05-31-2017 09:26 AM |
| Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
| Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
| find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |
Table with values from several locations and years - need to find comp values
Windows 8 
Office 2016
Threaded Mode