Thread: sumproduct??
View Single Post
 
Old 10-12-2012, 11:47 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

If you re-arrange your From-To charge table slightly you can use an approximate match to find the correct charge. Have a look at Example 1 here:
http://colinlegg.wordpress.com/2012/...-with-vlookup/

That example looks up grades by percentage, but it's the same principle.

The only reason to use SUMPRODUCT (or equivalent) would be if you want to calculate multiple charges and sum them in one go.
Reply With Quote