Sum to a certain cell

[routeski]

Hello,

I have built a very basic sheet to monitor sales at an event we are running, almost a bit like a till system. We are scanning barcodes which will represent products and then a final barcode to "end the transaction" which can also count the number of transactions. What I'm trying to achieve is everytime the 'end transaction' barcode is scanned, that the sum of total of everything up to the last end transaction is done.

For example

1345 | APPLES | $4
5566 | ORANGES | $3
3452 | BANANAS | $6
9999 | ENDTRANS | $0
3452 | BANANAS | $6
5566 | ORANGES | $3
9999 | ENDTRANS | $0

In this example, another cell will have $9 as the answer.

Hope this makes sense. Any help greatly received!

Mike

 

[Aladin Akyurek]

Is 9999 the code for "end the transaction"?

 

[routeski]

Is 9999 the code for "end the transaction"?

Yes it is. It might change, but I guess I could figure that part out

 

[Aladin Akyurek]

Yes it is. It might change, but I guess I could figure that part out

Control+shift+enter, not just enter:

=SUM(INDEX($C$1:$C$7,MATCH(9.99999999999999E+307,1/($A$1:$A$7=9999))):INDEX($C$1:$C$7,MAX(IF($A$1:$A$8=9999,IF(ROW($A$1:$A$7)-ROW($A$1)+1 < MATCH(9.99999999999999E+307,1/($A$1:$A$7=9999)),ROW($A$1:$A$7)-ROW($A$1)+1)))))