Trouble with COUNTIFS, HAS & NOT

Tim Dollmeyer

Hello,

I'm having trouble combining a couple functions in a COUNTIFS formula. Separately, they work fine, but combined they throw an INCORRECT ARGUEMENT SET error. The formula is:

COUNTIFS({GxP 7/8 Results}, NOT(ISBLANK(@cell)), {GxP Testers}, HAS(@cell, Tester@row))

I should say that {GxP Testers} references two adjacent multi-contact columns.

Any ideas on how to make this work?

Cory Page

I am pretty sure I understand what you're looking for but could you just verify real quick just in case..

It seems like you would like something like the below.

If @cell (Not sure which column that is though) isn't blank and Gxp Testers @cell (not sure what cell but whichever cell it is you want something in it) then count.

I feel an if statement with the countif might be easier maybe not though a bit more details would be helpful. Could you maybe paste the exact formula you have now? I also I dont believe Not and Has can be used in countif but I could be wrong.

Cory Page

I am pretty sure I understand what you're looking for but could you just verify real quick just in case..

It seems like you would like something like the below.

If @cell (Not sure which column that is though) isn't blank and Gxp Testers @cell (not sure what cell but whichever cell it is you want something in it) then count.

I feel an if statement with the countif might be easier maybe not though a bit more details would be helpful. Could you maybe paste the exact formula you have now? I also I dont believe Not and Has can be used in countif but I could be wrong.

Tim Dollmeyer

Thanks Cory!

I decided to use an OR statement instead of the NOT(ISBLANK) one and that worked.