C
claude jerry
I have a Excel File Saved on this below Link
http://www.savefile.com/files/1923737
A B C D E F G
Name Type Sun Mon Tue Wed Total
Joe Gold 5 5 2 12
Adam Silver 2 1 2 1 6
Sam Silver 3 3 2 2 10
David Blue 4 4 4 0 12
Sean Gold 3 3 3 2 11
Rod Silver 5 5 5 15
in Cell C:10 i have a Data Validation drop list =$C$1:$F$1
I want a formula which will give me the balance remaining of a particular
type depending on the selection in Cell C:10
Eg. If C:10 = mon
Balance Remain For = 7
It is much easier to understand if you can have a look at my excel file
saved on http://www.savefile.com/files/1923737
http://www.savefile.com/files/1923737
A B C D E F G
Name Type Sun Mon Tue Wed Total
Joe Gold 5 5 2 12
Adam Silver 2 1 2 1 6
Sam Silver 3 3 2 2 10
David Blue 4 4 4 0 12
Sean Gold 3 3 3 2 11
Rod Silver 5 5 5 15
in Cell C:10 i have a Data Validation drop list =$C$1:$F$1
I want a formula which will give me the balance remaining of a particular
type depending on the selection in Cell C:10
Eg. If C:10 = mon
Balance Remain For = 7
It is much easier to understand if you can have a look at my excel file
saved on http://www.savefile.com/files/1923737