LinkBack URL
About LinkBacks
Dear every GURU
how to write formula for make Total points.
For sample my picture
pic-9.GIF
BSG.
Dear every GURU
how to write formula for make Total points.
For sample my picture
pic-9.GIF
BSG.
Files are far more useful than pictures...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Sorry DonkeyOte
this sample file
Book3.xls
BSG
bet you're glad you asked dko!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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
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.Please Login or Register to view this content.
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
Revise such thatAnd i also try you formula but when i input 0
The table is error
Please Login or Register to view this content.
Thank you DonKeyOte is work full.
BSG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks