Addition of Logic Test Results

  • Thread starter Thread starter Charliemike83
  • Start date Start date
C

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
 
Hi
have a look at COUNTIF for example. e.g.
=COUNTIF(A1:A100,"X")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
MATCH not working in IF statement 6
Logical test in IF statement returning incorrect result 3
How can I test the text content of a cell 4
How do I write an IF function using dates? 2
Macro Question 8
function help-keeping data from true when false 8
Trouble constructing IF statement 1

Back
Top