[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
how to exclude certain row values from calculation in a table
From: |
Uwe Brauer |
Subject: |
how to exclude certain row values from calculation in a table |
Date: |
Mon, 06 Nov 2023 16:51:16 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
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/
- how to exclude certain row values from calculation in a table,
Uwe Brauer <=