count multi lines
 

I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,

count multi lines
 

Can you provide a little more information please... what are your "if"
conditions for each column (and any other condition you may be imposing)?

--
Rick (MVP - Excel)


"inungh" wrote in message
...
I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,

count multi lines
 

Can you provide a little more information please... what are your "if"
conditions for each column (and any other condition you may be imposing)?

--
Rick (MVP - Excel)


"inungh" wrote in message
...
I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,