Multiple column count

D Johnson

Need help with a formula. It is to count total sites upgraded either to a interim or final result, but if the site has had an interim and a final it is only counted once.

I have 2 columns with check boxes and need to count as 1 if a cell is checked in either column. If both cells in the 2 columns are checked also =1.

so 

1+0=1

0+1=1

1+1=1

Debbie Sawyer

Hello

Have you tried an IF function to set the value of the total column based on the presence of a tick in the box?  I re-created the scenario explained above using just a column 'a' and a column 'b' and 4 combinations of the tickboxes.  The same formula was used in each row resulting in the same totals as you gave in your scenario:

=IF(OR(a@row = 1, b@row = 1), 1)

I have attached a screen shot for extra reference.

Hope this helps - if I have mis-understood the scenario though, please do come back and ask for more

Kind regards

​Debbie Sawyer Consultant & Training Manager