Including 'check box' data in a formula

Bijal Shah

hello

I'm trying add the total IT hours in a project. I added column into my plan and checked all the resources classed as IT. When I ran the below formula it is not picking up the 2000+ hours and instead is giving me 0. Any advice where I am going wrong? thank you!

The Infor Nexus IT Team in the column that contains all checked IT resources.

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, "IT", {Infor Nexus Status}, "In Progress")

Heather Duff

Hi @Bijal Shah ,

Try this:

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, 1, {Infor Nexus Status}, "In Progress")

When you're searching for a checked box, the value is 1 for checked, or 0 for unchecked.

Let me know if it works!

Best,

Heather

Heather Duff

Hi @Bijal Shah ,

Try this:

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, 1, {Infor Nexus Status}, "In Progress")

When you're searching for a checked box, the value is 1 for checked, or 0 for unchecked.

Let me know if it works!

Best,

Heather

Bijal Shah

THANK YOU SO MUCH! it works a dream :)

Bijal Shah

Heather Duff

Glad it worked! :)