Use quotes when directly referencing a text value. If you are referencing a
cell (A2), you would use quotes only if using the INDIRECT() function.
Numeric values would not need quotes unless they are stored as text.

"Deb" wrote:

What are the guidelines as to when you do and do not use quotation marks in
the criteria section of a function.