B
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
X=10.
A B C D E
X X X 30
X X 20
THANK YOU
F
Frank Kabel
Hi
in E1
=COUNTIF(A1
1,"X")*10
and copy this down
in E1
=COUNTIF(A1
1,"X")*10and copy this down
J
JulieD
Hi Bob
=Countif(A11,"X")*10
fill down as required
Cheers
JulieD
=Countif(A1
1,"X")*10fill down as required
Cheers
JulieD
L
leon
Try
=COUNTIF(A2:F2,"X")*10
=COUNTIF(A2:F2,"X")*10
M
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.
=SUMIF(A2:F2,A1)
where the value you're looking for is in A1.