Microsoft Office Forums - View Single Post - Help with formulae please.

Thread: Help with formulae please.

View Single Post

Old

05-05-2022, 01:42 PM

ArviLaanemets ArviLaanemets is offline

ArviLaanemets is offline

ArviLaanemets uses Windows 8

Windows 8

ArviLaanemets uses Office 2016

Office 2016

Expert

Join Date: May 2017

Posts: 873

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

Default

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.

Reply With Quote