Countifs

DariusUsk

Hello All,

Maybe somebody could help me to set up formula where not blank cells would be counted.

At the moment I am using this formula =COUNTIFS({Type1}; "SIS"; {Done1}; 0; (NOT(ISBLANK{Instaliacijos pradžia1}))).

I've underlined part which is not working for me. I am bit weak with formulas so it might be what I wrote doesn't makes sense at all.

Thank you!

 

 

Paul Newcome

=COUNTIFS({Type1}; "SIS"; {Done1}; 0; NOT(ISBLANK(@cell)))

 

Give this a try...

DariusUsk

It still says #UNPARSEABLE.

Any other options?

Thanks!

Andrée Starå

Hi Darius,

What are the cross-sheet ranges?

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Glad we got it working!

Have a fantastic week!

Best,

Andrée