Multiple Criterion with Cross Sheets

Melanie S

Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time.

I have tried this formula =COUNTIFS({Complete Claim Status}, Status@row, {Vendor Name}, [Vendor Name]@row)

Complete Claim Status is the range on my cross sheet | Status@ row is from my main sheet

Vendor Name is the second range on my cross sheet | [Vendor Name]@row is from my main sheet and I have removed the brackets as well around that as well.

Here is a screenshot. Thank you for your assistance.

Mike TV

@Melanie S

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

This formula worked for me. I set up 2 separate test sheets like so:

The 2nd sheet in the Count column is where I placed that formula. It's setup with cross-sheet references as so:

Mike TV

@Melanie S

Hi Melanie. You don't have your criterion formatted quite right. Try this:

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

Melanie S

@Mike TV Thanks for your quick response. Unfortunately now I am getting another error.

Any ideas?

Mike TV

@Melanie S

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

This formula worked for me. I set up 2 separate test sheets like so:

The 2nd sheet in the Count column is where I placed that formula. It's setup with cross-sheet references as so:

Melanie S

@Mike TV Thank you!!