countifs formula works in cell but not in sheet summary

Victor Wang

Hi, All

I have this countifs formula - '=COUNTIFS([Point SysName]:[Point SysName], <>"", [Cable Roughed In?]:[Cable Roughed In?], 1)‌'.

When I put in in a cell, it works. But when I put in a sheet summary field, it comes up with an error message of '#UNPARSEABLE'.

In the attached photo, the number '2' is the result I am after for the two ticked boxes. You can see the error message in the sheet summary field on the right.

Any pointer will be much appreciated!

Thanks.

Victor

Victor Wang

Hi, Andree

I tried again this morning and it works this time.

I don't know what happened. I just retyped the formula again.

Thanks for your offer and follow-up.

Victor

Andrée Starå

Hi @Victor Wang

Strange!

It should work.

Can you share the exact formula in the Sheet Summary?

Also, try this one.

=COUNTIFS([Point SysName]:[Point SysName], <>"", [Cable Roughed In?]:[Cable Roughed In?], 1)

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(s) 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!

Victor Wang

Hi, Andree

thanks for your time.

I tried your formula but the same problem persists. I have uploaded below two screenshots showing the formula in the cell and in the sheet summary field.

I can not see that is any difference in syntax in them.

I hope I am not missing the obvious.

Thanks.

Victor.

Andrée Starå

@Victor Wang

Happy to help!

Strange!

I'd be happy to take a quick look.

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)

Victor Wang

Hi, Andree

I tried again this morning and it works this time.

I don't know what happened. I just retyped the formula again.

Thanks for your offer and follow-up.

Victor

Andrée Starå

@Victor Wang

You're more than welcome!

Glad to hear that it's working now!