Help with formula

Jon Barto

I need some help with a formula.

See sheet summary.

I just need help with the first one "move in items open" and I can apply the same formula structure to the rest.

I want to count the amount of Warranty phase column if that says "move in items" and the status is Not started or In progress" and have that be 1 number.

Any help would be greatly appreciated.

Jon

Carson Penticuff

Give this a try:

=COUNTIFS([Warranty Phase]:[Warranty Phase], "Move in Items", [Status]:[Status], OR(@cell = "In Progress", @cell = "Not Started"))

Carson Penticuff

Give this a try:

=COUNTIFS([Warranty Phase]:[Warranty Phase], "Move in Items", [Status]:[Status], OR(@cell = "In Progress", @cell = "Not Started"))

Jon Barto

Perfect!

Thanks so much Carson!