Paper Business

EXCEL

Funcao COUNTIF

Countif(Range,criteria)

Objective: Counting the number of cells within a range that meet the given criteria.

Example: check if one item number is repeated in the worksheet.

Column B contains the item numbers

Label on the cell B1

Then formula is COUNTIF(B$2:B2,B2) if appears 1 it means that is the first time this item number appears

Example: item number 23 ---- 1 (1 means it’s the first time it appears)

Item number 23 ---- 2 (2 means the second time it appears)

On the coming cells will appears

(for example cell B4...