Help with formulae please.

DelH · #7 05-17-2022, 02:42 AM

Quote:

Originally Posted by ArviLaanemets

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.

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