2021 Archives by date, by thread · List index

# Re: [libreoffice-users] Updating Data in Calc

```Dear Brian,

On 2021/06/13 18:52, Brian Barker wrote:
```
```At 15:01 13/06/2021 +0200, Hylton Conacher wrote:
```
```A simple sum will do it i.e.: In cell Y4 insert [...]
=SUM(M18-\$W\$4)
```
```
```
I'm often puzzled by suggestions such as this. In what way do you think that =SUM(Xm-Yn) differs from =Xm-Yn? The minus sign effects the subtraction between two values, generating a single value as its result. You then pass this single value to the SUM() function. What do you expect that function do with a single value? The sum of two and two is four; what do you think is the sum of just two?
```
```
I too was puzzled by the OP post however I assumed that it was the function that the OP was seeking, consequently my answer included the SUM option. The two formulae above do indeed calculate the same thing, but as you can see from the OP reply, he perhaps wanted a more Index(Match()) query.
```
```
I will leave the explanation of the different parts of whatever function he chooses to someone who has knowledge of such.
```
```
It has often puzzled me why when knowledgeable members of mailing lists such as this, find fault in what someone, less qualified than themselves, suggests. It is not taken via private mail but splashed on the mailing list.
```
```
I have been very thankful for your help in years past, and despite an endeavour to understand the Index/Match formula I am still battling with what cell selections go where in the formula. Perhaps in showing the OP verbosely you will allow both him, I and perhaps a few others also understand the formula, if you think it is the one needed.
```
I, and many others, look forward to your continued support.

Warmest Regards
Hylton

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/