#Incorrect Argument Set with =COUNTIFS

DKazatsky · 01/11/23

Hi all,

This is baffling me. I have a very simple formula...

=COUNTIFS({Epic Name}, [Primary Column]@row, {Current Sprint}, 1).

I am using this for a metrics sheet to be used for dashboard reporting. This is working as expected in it's own sheet but when I use the exact same formula in a bigger/consolidated metric sheet, it returns "#Incorrect Argument Set".

Does anyone know why it works on one sheet but not another?

Thanks,

Dave

DKazatsky · 01/11/23

Update:

It looks like the reference was the issue when I cut/paste the formula. Even thought the same reference was being used in the current sheet, when I reinitialized the reference, everything worked as expcted.

Thanks.

DKazatsky · 01/11/23

Update:

It looks like the reference was the issue when I cut/paste the formula. Even thought the same reference was being used in the current sheet, when I reinitialized the reference, everything worked as expcted.

Thanks.