emacs-orgmode
[Top][All Lists]
Advanced

[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/




reply via email to

[Prev in Thread] Current Thread [Next in Thread]