2013 Archives by date, by thread · List index

# Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

```Brian Barker wrote:
```
```At 12:58 08/09/2013 -0300, Bruno Schneider wrote:
```
```(omissions for brevity)
```
```
=SUMPRODUCT(B\$2:B\$5=E1;C\$2:C\$5)
so you can fill this down into F2.

How does this second method work?  Well, the test of equality gives a
value which can be interpreted as a number: 1 for TRUE and 0 for
FALSE.  Multiplying this by your "value" switches each value on or off
in the sum.

I trust this helps.

Brian Barker
```
```Typo found :  switch the B's and C's so that the function reads:
=SUMPRODUCT(C\$2:C\$7,E1=B\$2:B\$7)
and it works.
Thanks ... I did enjoy that, and I learned something!
Regards
Fred James

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```