View Single Post
 
Old 05-17-2022, 02:42 AM
DelH DelH is offline Windows 10 Office 2016
Novice
 
Join Date: May 2022
Posts: 4
DelH is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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.
Thanks to both Avril and Steve, but I have been sent a formulae which involves minimal changes and uses VLOOKUP, INDEX and MAPPING. Thanks anyway.
Reply With Quote