COUNTIFS Reference another sheet #UNPARSABLE

Michael Methe

Hello,

I am trying to use COUNTIFS to count the occurrences of 'On Call' in one range and 'Account' in another range. Both ranges are in another sheet.

=COUNTIFS({From_Trackit_Data Range 8}, "On Call", {From_Trackit_Data Range 7},"Account")

What am I doing wrong?

Thanks!

Dale Murphy

@Michael Methe I would troubleshoot with =countif({From_Trackit_Data Range 8}, "On Call"), If that works, try adding the second condition.

(I suspect you have a wee issue with one of the range definitions.)

dm

Paul Newcome

Are you getting an error message or an incorrect count?

Michael Methe

I was getting unparsable. Now I am getting a count, but incorrect.

I can filter the sheet on those ranges and see there are 100+ matching records though.

=COUNTIFS({From_Trackit_Data Range 8}, "On Call", {From_Trackit_Data Range 7}, "Accounts")

screen cap of data

Paul Newcome

How many are you getting vs how many should you have?

How exactly are you creating your cross sheet references?