FIND CELL (i.e-a1:c4) and or count cells of merge cells through formula

[INCOMETAX111]

i have data on "a1:c4" and i want to count or display this on "d1" using formula ..how is possible ?

 

[S. Das]

Hi, please share the sample file.

 

[pecoflyer]

And PLEASE, except for cosmetic reasons, AVOID merged cells. They are nothing but trouble

 

[Chihiro]

If it's text...
=COUNTA(A1:C4)

If numeric
=COUNT(A1:C4)

But as pecoflyer mentioned. Just don't use merged range.

 

[ashakantasharma]

You can also use =COUNTIF & =COUNTIFS if you want to count cells that match specific criteria.