Hi all

Please look at 

|   |  Price |
|---+--------|
| / |  10.98 |
|   |  11.90 |
|   |  19.98 |
|   |  13.79 |
|   |  29.97 |
|   |  18.98 |
|   |  13.79 |
|   |  11.90 |
|   |  24.28 |
|---+--------|
|   | 155.57 |
#+TBLFM: @11$2=vsum(@I$2..@II$2);f2

I would like to exclude the first value from the sum by adding some mark
in that row.

Of course, I also could use 
|   |  Price |
|---+--------|
| / |  10.98 |
|---+--------|
|   |  11.90 |
|   |  19.98 |
|   |  13.79 |
|   |  29.97 |
|   |  18.98 |
|   |  13.79 |
|   |  11.90 |
|   |  24.28 |
|---+--------|
|   | 144.59 |
#+TBLFM: @11$2=vsum(@II$2..@III$2);f2

But suppose the value I'd like to exclude would be 29.97, then I would
need some reordering, I prefer to avoid.

Any idea how to exclude row values in a column?


Regards

Uwe Brauer 


-- 
I strongly condemn Hamas heinous atrocities on Israel, especially the 
despicable pogroms.
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the NATO membership of Ukraine.
I support the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/


Reply via email to