• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Output basis of a grid

Sriram Iyengar

New Member
Row #F73 mentions the distance between point A & B
The Table titled new earn table mentions a grid.
G73 to AC 73 mention the num of passengers travelling in every class (e.g.
K S Q L N U T M Y)
The Table on the top has the number of miles he will get basis of the class of travel
In AF 73 i need the total points that will be awarded across that sector

I am currently typing the formula manually but is there an easier way to do it?
Worksheet Name QFF on 9W9W V2

Please help me !! :(

Thamls
 

Attachments

  • QF changes - new calculations v2.xlsx
    118.8 KB · Views: 0
Hi Sriram ,

Try this :

=SUMPRODUCT(($L73:$Y73)*INDEX($G$53:$T$62,MATCH($F73,$F$53:$F$62),N(IF(1,MATCH($L$64:$Y$64,$G$36:$T$36,0)))))

This is an array formula , to be entered using CTRL SHIFT ENTER.

Narayan
 
Hi Sriram ,

Sorry , my mistake.

I forgot to mention that I had changed the values in your new earn table from the slabs you have shown to only the lower limit values i.e. instead of 0 - 250 , enter 0 , instead of 251 - 500 enter 251 ,..., instead of 6501+ enter 6501

Narayan
 
Back
Top