I need to sumif a column if a checkbox is not checked.

David Noland

Hi - I need to sum the supplier score column if the checkbox on the row is NOT checked.

Thanks for your help!

DN

Andrée Starå

Hi David,

Try something like this.

=SUMIF([N/A]:[N/A]; 0; Score:Score)

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

=SUMIF([N/A]:[N/A], 0, Score:Score)

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

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

David Noland

Thanks but I get an #unparseable error with that statement

Andrée Starå

@David Noland

Happy to help!

I forgot to write that you need to change my column names to match yours.

Make sense? Did that fix it?

David Noland

Still #unparseable. I changed the column name to Score to match your formula.

Andrée Starå

Strange!

Can you share the exact formula you are using?

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

David Noland

I also changed the N/A to NA thinking that the formula does not like the column name with the "/" in it.

David Noland

Formula is =SUMIF([NA]:[NA], 0, Score:Score)

Columns are NA and Score

Andrée Starå

Thanks!

Try this.

=SUMIF(NA:NA, 0, Score:Score)

Did it work?

David Noland

#unparseable

Andrée Starå

Can you paste another formula you are using in your sheet?

If you can it would be simplest if you can share the sheet or a copy of it.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

David Noland

Sheet is shared - Thanks for your help!

Andrée Starå

@David Noland

Glad we got it working! 

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Dana Folsom

what was the final formula used on this?

Andrée Starå

@Dana Folsom

I'll get back to the post if I find it, but I think I fixed it in David's sheet so I don't have it anymore.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Dana Folsom

no probllem.. just curious.