Total points

[9khonnei]

Dear every GURU
how to write formula for make Total points.
For sample my picture

pic-9.GIF

BSG.

[DonkeyOte]

Files are far more useful than pictures...

[9khonnei]

Sorry DonkeyOte
this sample file
Book3.xls

BSG

[martindwilson]

bet you're glad you asked dko!

[DonkeyOte]

You can use INDEX here...

Based on your sample file I would first add two rows of calcs beneath the tables to reduce repetitive calcs

Please Login or Register  to view this content.

Once these are in place you can then use the following:

Please Login or Register  to view this content.

As you adjust entries in either input table (M3:V12 / B16:I25) so you should find your 8 tables adjust accordingly.

[9khonnei]

Thank you Too Much DonkeyOte.
I so sorry my misstake to inform on this Top Table i want to show the Calculate total point only unconcerned.

sample file : Book3.0.xls

And i also try you formula but when i input 0
The table is error
see this file after use formula : Book3.1.xls

Thank you inadvance

[DonkeyOte]

And i also try you formula but when i input 0
The table is error

Revise such that

Please Login or Register  to view this content.

[9khonnei]

Thank you DonKeyOte is work full.

BSG