Your understanding is correct, Esther. Any is normally used with plural and uncountable nouns in questions, negative and conditional sentences: Do we have any beer? ~ Yes, we do. It's in the fridge.

Chances are that this noun is called a mass noun. Mass nouns are nouns that, by their very nature, are plural. These are also called uncountable nouns or noncount nouns. The phrases “water,” “rice,” ...