Help with Countifs with multiple criteria

[trone77]

Wondering if there is a way to execute the formula below using countifs?


=countifs('[AY.xlsx]1998-2015'!$W$1:$W$8766,$M5)+countifs('[AY.xlsx]1998-2015'!$W$1:$W$8766,$N5),'[AY.xlsx]1998-2015'!$C$1:$C$8766,$Q5,'[AY.xlsx]1998-2015'!$X$1:$X$8766,$O5,'[AY.xlsx]1998-2015'!$Y$1:$Y$8766,U$3,'[AY.xlsx]1998-2015'!$Z$1:$Z$8766,$AH$2,'[AY.xlsx]1998-2015'!$AA$1:$AA$8766>=$AZ$2,'[AY.xlsx]1998-2015'!$AA$1:$AA$8766,$AZ$3))

 

[jasonb75]

The last bracket and the one after $N5 shouldn't be there, delete those and it should work.

 

[trone77]

The last bracket and the one after $N5 shouldn't be there, delete those and it should work.

The last bracket and the one after $N5 shouldn't be there, delete those and it should work.

Thanks for the reply. However after removing the bracket after $N5 and the one at the end, there still returns the error too few arguments. Is there alternative formula without an array that would work?

 

[jasonb75]

Not sure why you're seeing a 'too few arguments' error, there is a syntax error that I missed.

=countifs('[AY.xlsx]1998-2015'!$W$1:$W$8766,$M5)+countifs('[AY.xlsx]1998-2015'!$W$1:$W$8766,$N5,'[AY.xlsx]1998-2015'!$C$1:$C$8766,$Q5,'[AY.xlsx]1998-2015'!$X$1:$X$8766,$O5,'[AY.xlsx]1998-2015'!$Y$1:$Y$8766,U$3,'[AY.xlsx]1998-2015'!$Z$1:$Z$8766,$AH$2,'[AY.xlsx]1998-2015'!$AA$1:$AA$8766">="&$AZ$2,'[AY.xlsx]1998-2015'!$AA$1:$AA$8766,$AZ$3)

Some of the criteria look a bit dubious, as far as I can see the syntax is now correct, but whether or not the formula will give you the result that you want is something totally different.

I suspect that $AZ$3 at the end of the formula should actually be "<="&$AZ$3