help with sum / count formula
 

Hi,

Does anyone know how I can write the following formula...

I have different references in coloumn B and random cells filled in from
coloumns C-F.

I want the formula to count how many cells have data in them from C1 - F100,
but only if coloumn B contains the reference in A1.

eg

A B C D E F
1 ZZZ ZXY aaa acd
2 ZZZ abc aaa
3 YYY aaa

I would want the formula to show 2 from the above data, as there are 2 cells
filled in, where coloumn B = A1.

I wasn't sure if it's a sum or count formula, any help would be great.

Thanks