|
|
#5
05-05-2022, 01:42 PM
|
|||
|
|||
My advice is use a single table instead of 3 tables, like:
MinDistance, MaxDistance, Type, Plums, MinValue, MaxValue 200 250 A 2 89 92 200 250 A 3 92 94 ... 450 550 E 11 100 110 ... 450 550 H 11 100 110 Now your calculation will be a simple SUMIFS() formula. 
|
| Tags |
| index and match, lookup, vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Keep formulae pointed to same cell
|
Mechaman | Excel | 2 | 04-11-2021 02:54 AM |
| Excel thinks I am creating a formulae | TimTDP | Excel | 2 | 07-28-2020 12:30 PM |
| What's wrong with formulae? | kingston123 | Excel | 5 | 06-29-2020 10:55 AM |
| help with formulae | Zoemoe | Excel | 3 | 07-02-2017 05:40 PM |
|
Use NUMPAGES in formulae
|
Friedebarth | Word | 1 | 11-30-2011 02:22 PM |
Windows 8 
Office 2016
Threaded Mode