Incorrect Argument - Second set of eyes please

Hollie Green

I'm not sure what I'm missing but would appreciate some help with the below formula it is giving me an incorrect argument set and I can't figure out why.

=COUNTIFS({Greet}, OR(@cell = "yes", @cell = "NA"), {Week Beginning}, [Report Date]@row, {Monitor Type}, "Monitor") / COUNTIFS({Greet}, OR(@cell = "yes", @cell = "no", @cell = "NA"), {Week Beginning}, [Report Date]@row, {Monitor Type}, "Monitor")

Paul Newcome

Syntax is right, so the other thing that can cause that error is range sizes not matching. Double check your cross sheet references to ensure they are all the same size and shape.

I have trouble sometimes with this when I am referencing a large sheet or my internet is behaving poorly. Sometimes it takes a few extra seconds for the sheet to fully load in when you are selecting the range for the cross sheet reference. When the sheet does fully load in, the selection will always revert to the "home cell" or the cell in the top right corner. Even if you have already clicked on a column header. Then I have to go back and edit the reference and pause for a few seconds to let the sheet load into the window. You should be good to go when the sheet name appears near the top left of the window.

Paul Newcome

Syntax is right, so the other thing that can cause that error is range sizes not matching. Double check your cross sheet references to ensure they are all the same size and shape.

I have trouble sometimes with this when I am referencing a large sheet or my internet is behaving poorly. Sometimes it takes a few extra seconds for the sheet to fully load in when you are selecting the range for the cross sheet reference. When the sheet does fully load in, the selection will always revert to the "home cell" or the cell in the top right corner. Even if you have already clicked on a column header. Then I have to go back and edit the reference and pause for a few seconds to let the sheet load into the window. You should be good to go when the sheet name appears near the top left of the window.

Hollie Green

@Paul Newcome Thank you so much! That fixed it!

Paul Newcome

Happy to help. 👍️