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

 

 

Paul Newcome

Try something like this...

 

=IF(COUNTIFS([First Checkbox Column]@row:[Second Checkbox Column]@row, 1) > 0, 1)

Andrée Starå

Hi,

Try something like this.

=IF(OR(A@row = 1; B@row = 1); 1)

The same version but with the below changes for your and others convenience.

=IF(OR(A@row = 1, B@row = 1), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

D Johnson

Thank you everyone

Andrée Starå

Happy to help!

D Johnson

Excellent 

IF i have used, OR is new to me 

Thank you