COUNTIFS Formula with Cross Sheet Reference

Megan Harry

Hello,

I am trying to do a countifs formula and I need to reference two columns in another sheet. I have copied the formula I am trying to use below.

=COUNTIFS({2020 Q4 Validations Range 2}, OR(@cell = "Amazon"), {2020 Q4 Validations Range 3}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))

I keep getting #INCORRECT ARGUMENT SET

I would greatly appreciate some help!

Paul Newcome

=COUNTIFS({2020 Q4 Validations Range 2}, "Amazon", {2020 Q4 Validations Range 3}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))

If that is still giving you an error, make sure your ranges are the same size by clicking on the column header when creating each range to select the entire column.

Paul Newcome

The only real difference is that I removed the OR function as it was not needed.

Paul Newcome

=COUNTIFS({2020 Q4 Validations Range 2}, "Amazon", {2020 Q4 Validations Range 3}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))

If that is still giving you an error, make sure your ranges are the same size by clicking on the column header when creating each range to select the entire column.

Megan Harry

@Paul Newcome Thank you!! My initial formula is actually now working! i have no idea why because I did not change anything. Maybe just a glitch?

Would you consider the formula you provided the better way to go?

Paul Newcome

The only real difference is that I removed the OR function as it was not needed.

Michelle Clifton

@Paul Newcome curious if you know why clicking the header would cause the #incorrect argument set to pop up when I am starting the formula? i.e. I enter countifs( then click the header and get the error. I have been searching the various threads for a while and have not come up with anything.(I am new to Smart Sheets, so guessing it is something I am doing wrong) thanks for any ideas. Also apologies if it is bad etiquette to ask this in this thread. :)

Paul Newcome

@Michelle Clifton It could be a number of things. Is the error still present when you finish out the formula?