I'm working with a large database and trying to write a countifs function.
Each part of the function works independently and some of them work together,
but when I try to add them all together, I get a #value error. I've given
each column in my database a range name to make copying functions easier.

This function works and gives a correct answer:
=COUNTIFS(Pre_DS,"0.99",Pre_DS,"<2")

This function works and gives a correct answer:
=COUNTIFS(Tx_Type,"cha",Pre_Cyl,"<-1.99",POM_3_UCVA,20)

This function gives me a #value error
=COUNTIFS(Tx_Type,"cha",Pre_Cyl,"<-1.99",POM_3_UCVA,20,Pre_DS,"0.99",Pre_DS,"<2")