Addition of Logic Test Results

[Charliemike83]

Hey Ho

Does anyone know how to add the results of a logic test if the result
are 1 for TRUE & 0 for FALSE

Cheer

 

[Frank Kabel]

Hi
have a look at COUNTIF for example. e.g.
=COUNTIF(A1:A100,"X")

 

[Andy B]

Hi

Try:
=SUMPRODUCT((A2:A10)*1)
or
=A2+A3+A4+A5+A6+A7+A8+A9+A10

 

[Charliemike83]

Hey ho

Thanks guys finally got it to work!!

CM