what is the (countif) formula for a spread sheet in excel?

0 ⤊

what is the (countif) formula for a spread sheet in excel?

this is for data analysing

2007-01-22 05:09:46 · 3 answers · asked by ? 1 in Computers & Internet ➔ Other - Computers

3 answers

It counts the number of cells that satisfies criteria that you set.

So for example

=countif(a1:a100,9) Will count how many cells from A1 to A100 that is "9".

2007-01-22 05:13:26 · answer #1 · answered by Anonymous · 0⤊ 0⤋

It counts the number of cells within a range for a given criteria. For example, if you wanted to know how many of the cells in the C1-c100 column have the value Y, you could use:

=countif(c1:c100,"Y")

2007-01-22 13:16:51 · answer #2 · answered by BigRez 6 · 0⤊ 0⤋

Count If:

Counts the number of cells that meet a set set/certain criteria...

2007-01-22 13:16:54 · answer #3 · answered by Chεεrs [uk] 7 · 0⤊ 0⤋