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: [email protected]
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
