COUNTIFS with reference to another sheet more than one criterion

I'm very confused about this function. It has an #UNPARASABLE error.

=countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter")

I am trying to reference three columns from another sheet, Jade2_BCM Dashboard, to see how many rows are marketed as complete, are from the 1st Quarter, and are under Business Resilience. Does anyone know why I am getting this error?

Find more posts tagged with

Formulas

Comments

Frank Falco

Try removing the [ in "Complete",[{Jade2_BCM Dashboard 2019 Range 2}, the [ ] are used when referencing a column name in the same sheet that has a space in it, it is not required when referencing columns in another sheet.

Jade-L

Thank you! That worked. I no longer have an error.

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…