Considereu la taula segĂĽent

A

B

C

1

Nom del producte

Sales

Revenue

2

llapis

20

65

3

llapis

35

85

4

bloc de notes

20

190

5

llibre

17

180

6

pencil-case

not

not


warning

En tots els exemples següents, els intervals del càlcul contenen la fila 6, la qual és ignorada perquè conté text.


Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]]

note

The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Func_Range is taken into calculation.


Func_Range and Range1, Range2... must have the same size, otherwise the function returns err:502 - Invalid argument.

Range1 – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied.

Criterion: A criterion is a single cell Reference, Number or Text. It is used in comparisons with cell contents.

A reference to an empty cell is interpreted as the numeric value 0.

A matching expression can be:

Range2 – Optional. Range2 and all the following mean the same as Range1.

Criterion2 – Optional. Criterion2 and all the following mean the same as Criterion.

The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them.

If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).

Ens cal la vostra ajuda!