6

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

Department

Comments

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([email protected] = 1, [email protected] = 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

 

 

Try something like this...

 

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

Hi,

Try something like this.

=IF(OR([email protected] = 1; [email protected] = 1); 1)

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

=IF(OR([email protected] = 1, [email protected] = 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

Thank you everyone