COUNTIFS

Aiva

Hi All,

I've been trying to put a metric in place for my dashboard which splits up how many tasks are Open or Closed within certain division. I am referencing the main works sheet and columns there for the range. I was also trying to reference my metric sheet for cell values for Open/Closed and specific division but gave up as nothing works. I tried leaving gaps between commas, I tried no brackets...

Latest formula I have tried which gives #UNPARSEABLE

=COUNTIFS({STATUS}:{STATUS},''Open'',[{Division}:{Division}],''Construction'')

Any tips of what I am doing wrong be great!

Paul Newcome

And you are definitely getting the Unparseable error? Did you double check that you did in fact use quotes instead of double apostrophes?

Scott Orsey

Hi @Aiva , The proper syntax for your formula would be:

=COUNTIFS({STATUS},''Open'',{Division},''Construction'')

Also, {Status} and {Division} must be from the same remote sheet. Your explanation makes me think they may be from different sheets, and, if so, that will not work.

Good luck and be well!

Aiva

@Scott Orsey Thank you, both {Status} and {Division} are from the same master sheet where data is collated however I'm still getting the same UNPARSEABLE, any ideas what else may be wrong?

Paul Newcome

Can you provide a screenshot of the formula actually open in the sheet as if you are about to edit it?

Aiva

@Paul Newcome

Paul Newcome

DO you normally use commas in between sections of your formulas, or do you usually use semi-colons?

Aiva

Usually commas

Paul Newcome

And you are definitely getting the Unparseable error? Did you double check that you did in fact use quotes instead of double apostrophes?

Aiva

@Paul Newcome it had shown the error but it turns out formula did not have the correct quotation signs... I have no words... Thank you!