#1
|
|||
|
|||
Sum and Lookup multiple values
Hi
I have a workbook, in one sheet I have a list of months/years e.g. Oct 2017, Sept 17 etc, also beside these dates I have Categories and then a value. In the same workbook on a different tab, I want to be able to enter a from and to date and that will then sum up the values for specific categories from the other sheet. Can anyone help with this? Many thanks Will |
#2
|
|||
|
|||
See the attached.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match multiple lookup values? | tinfanide | Excel | 3 | 07-02-2017 05:35 AM |
Lookup and replace cell values | rgauss | Excel | 3 | 10-03-2016 04:01 PM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
using two lookup values to get a sum figur | Ian A King | Excel | 3 | 05-18-2015 02:56 PM |
Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |