add Xs where X=10

[Bob]

Looking for formula to add "X"s across a row where each
X=10.

A B C D E
X X X 30
X X 20

THANK YOU

 

[Frank Kabel]

Hi
in E1
=COUNTIF(A11,"X")*10
and copy this down

 

[JulieD]

Hi Bob

=Countif(A11,"X")*10

fill down as required

Cheers
JulieD

 

[leon]

Try
=COUNTIF(A2:F2,"X")*10

 

[Myrna Larson]

In case you want to search for other values, a more generic formula is

=SUMIF(A2:F2,A1)

where the value you're looking for is in A1.