Error - #INCORRECT ARGUMENT SET

Kelly R.

Hello,

Could use some help on a formula please. I am wanting to pull the number of open complaints by month that are over 30 business days and labeled private label. For some reason I receive this error - #INCORRECT ARGUMENT SET

My formula is below:

=COUNTIFS({Test Range 2}, Month@row, {Test Range 2}, "Private Label", {Test Range 4}, "Open", {Test Range 3}, "Over 30 Business Days").

Appreciate any and all support.

Kelly

Paul McGuinness

Hi @Kelly R.

I notice in your formula you have [Test Range 2] twice being referred to for the month and private label?

That would likely cause an incorrect argument as the different format on the fields - Month@row vs text lookup.

If you amend the range details that should sort it for you.

Hope that helps

Thanks

Paul

Paul McGuinness

Hi @Kelly R.

I notice in your formula you have [Test Range 2] twice being referred to for the month and private label?

That would likely cause an incorrect argument as the different format on the fields - Month@row vs text lookup.

If you amend the range details that should sort it for you.

Hope that helps

Thanks

Paul

Kelly R.

Hi Paul,

Thank you for your help and I apologize for my simple oversight. I made the fix and worked.

Kelly