2012 Archives by date, by thread · List index

# [libreoffice-users] how to use sumif with multiple condition and refer to cell in formula

```Hi,

I have some, I think not to simple problem in Calc.

I have this table:
A    B    C
3    a    1
4    b    1
5    b    0
7    a    0
5    a    1
7    b    0
0    b    1

```
How can I totalize in one formula (without use a D column) the values in column A, only when the column B="a" and the C=1?
```
```
And the another question, which resolve the first problem too, how can I refer to a test cell the example in sumif formula:
```The correct formula:
=SUMIF(C1:C7;1;A1:A7)

What I want:
=SUMIF(C1:C7;*Cx*+3=1;A1:A7)

where Cx is actually examined cell (C1, C2, C3, ...)

or in this example:
A    B    C
3    1    1
4    0    1
5    1    0
7    0    0
5    1    1
7    0    0
0    0    1

=SUMIF(C1:C7;*AND(Bx, Cx)*;A1:A7)
when Bx=1 and Cx=1, I want to totalize the values in A column.

--
Nagy Ákos

--
For unsubscribe instructions e-mail to: users+help@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
```