Formula To Count How Many Cells In A Row Has Values In

[Dazzawm]

Is there a formula to count how many cells within a row contains a value please like below

11072	11073	11258 So 3 in this row
11072	11073	11258 So 3 in this row
11072	11265	11266 So 3 in this row
11072	11265	11266 So 3 in this row
11072	11265	So 2 in this row
		So 0 in this row
11073	11257	11258 So 3 in this row
11073	11257	11258 So 3 in this row
11073	11257	11258 So 3 in this row

These are columns B, C & D so I would enter the result in E. 3, 2, 0 and so on...

 

[bebo021999]

E1:
=COUNT(B1:D1)

 

[Dazzawm]

E1:
=COUNT(B1:D1)

That returns zero for everything? Does it matter what type of values are in each cell?

 

[Peter_SSs]

Does it matter what type of values are in each cell?

Yes, COUNT counts numerical values. If you want to count any values use COUNTA instead.

 

[Dazzawm]

Yes, COUNT counts numerical values. If you want to count any values use COUNTA instead.

That worked, much obliged squire.

 

[Peter_SSs]

Glad we could help.