IFerror index problems, Im stuck

[DonBDK]

Hi I use this formula to calculate losses in weight and it works fine:
=IFERROR(INDEX(C10:C62;MATCH(9^9;C10:C62))-C6;"")
When I use the C10:c62 it works fine.

The problem is that i also want to use 6 cells not in a row, like C10, C14, C16, C20, C22, C24
I just cant get the formula to work.
=IFERROR(INDEX(C10;C14;C16;C20;C22;C24;MATCH(9^9;C10;C14;C16;C20;C22;C24))-C6;"")

 

[Aladin Akyurek]

=(LOOKUP(9,99999999999999E+307;CHOOSE(ROW(INDIRECT("1:"&COUNT(C10;C14;C16;C20;C22;C24)));C10;C14;C16;C20;C22;C24)))-C7

Its still not working. I can get the data from the first cell, but nothing happens when i put data into the other cell-.

I guess you are not going to post the output that you need for the input given in post #9.

 

[DonBDK]

I guess you are not going to post the output that you need for the input given in post #9.

Im am not that good in english but i will try to explain it again.

Cell C1 is the cell with the formula
Cell C2 is the reference Cell C2 = 100

Cell C3 Gets the input 80
Cell C5 is blank
Cell C8 is blank
Cell c10 is blank

Cell C1 will display C2-C3 = 100 - 80 = 20

Then after one week i will write new data but this time to cell C5

Cell C3 = 80
Cell C5 = 79
Cell C8 is blank
Cell c10 is blank

Cell C1 should then display C2-C5 = 100 - 79 = 21
Because this is a new typing


Then after one week i will write new data but this time to cell C8

Cell C3 = 80
Cell C5 = 79
Cell C8 is 81
Cell c10 is blank

Cell C1 should then display C2-C5 = 100 - 81 = 19
Because this is the newest typing.

 

[Aladin Akyurek]

In C1 enter:

=IFERROR(C2-LOOKUP(9.99999999999999E+307,C3:INDEX(C:C,MATCH(9.99999999999999E+307,C:C))),"")

 

[DonBDK]

In C1 enter:

=IFERROR(C2-LOOKUP(9.99999999999999E+307,C3:INDEX(C:C,MATCH(9.99999999999999E+307,C:C))),"")[/QUO

Thanks for the good reply, but its still not a row but several cells.
Because there is other data in the other cells.

And its the same problem for me understading how to add several cells instead of entire column.