Documentation/SL/How Tos/Calc: funkcija SUMIF

From Apache OpenOffice Wiki
Jump to: navigation, search


Pogojno sešteje vsebino celic v danem obsegu.


SUMIF(poskusni_obseg; pogoj; obseg_vsote)

Ta funkcija identifies those cells in the range test_range that meet the condition, and sums the corresponding cells in the range sum_range. If sum_range is omitted the cells in test_range are summed.
pogoj je lahko:
število, kot je 34,5
izraz, kot je 2/3 ali SQRT(B5)
besedilni niz
SUMIF looks for cells in test_range that are equal to condition, unless condition is a text string that starts with a comparator:
>, <, >=, <=, =, <>
In this case SUMIF compares those cells in test_range with the remainder of the text string (interpreted as a number if possible or text otherwise).
For example the condition “>4.5” tests if the content of each cell is greater than the number 4.5, and the condition “<dog” tests if the content of each cell would come alphabetically before the text dog.

It can be very important preverite nastavitve v pogovornem oknu Orodja – Možnosti - Calc - Izračuni:
If the checkbox is ticked for search criteria = and <> must apply to whole cells, then the condition “red” will match only red; if unticked it will match red, Fred, red herring.
If the checkbox is ticked for Enable regular expressions in formulas, the condition will match z uporabo regularnih izrazov - so for example "r.d" will match red, rod, rid, and "red.*" will match red, redraw, redden.
The checkbox for Case sensitive has no effect (no attention is paid to case). See the examples for how to achieve a case sensitive match.

Blank (empty) cells in test_range are ignored (they never satisfy the condition).
condition can only specify one single condition. See Pogojno štetje in seštevanje for ways to specify multiple conditions.



vrne vsoto negativnih števil v obsegu A1:A9.

SUMIF(A1:A9; F1)

where F1 contains the text >=0 (without double quotes) returns the sum of the positive numbers in A1:A9.

SUMIF(B2:B4; "<"&F2; C2:C4)

where F2 contains 10 and cells B2, B3, B4 contain 7, 9, 11, returns the sum of C2 and C3, because cells B2 and B3 are less than 10.

SUMIF(D1:D9; "apples"; E1:E9)

where cells in D1:D9 contain either apples or pears and cells in E1:E9 contain the corresponding quantities of each fruit, returns the total quantity of apples.

Napredna tema:

SUMPRODUCT(D1:D9="Jabolka"; E1:E9).

vrne vsoto vnosov v obsegu E1:E9, katerih ustrezen vnos v obsegu D1:D9 se ujema z Jabolka z razlikovanjem med velikimi in malimi črkami (vnosa jabolka in JABOLKA se ne ujemata). Za podrobnosti si oglejte Pogojno štetje in seštevanje.

See also:


Matematične funkcije

Pogojno štetje in seštevanje

Regularni izrazi in Calc

Personal tools
In other languages