# Multiple column count

Options
edited 12/09/19

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

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Try something like this...

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

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thank you everyone

• ✭✭✭✭✭✭
Options

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Excellent

IF i have used, OR is new to me

Thank you