Home > OS >  Google Sheets Query: Multiple Values in a Single Cell Reference, is it possible?
Google Sheets Query: Multiple Values in a Single Cell Reference, is it possible?

Time:03-11

Good morning!

I want to ask if it is possible that the cell reference for "houses" on "worksheet!C3" return values for A&B only or A&C only or B&C only while only using one cell ("worksheet!C3") as cell reference, or is there a better approach on trying to return the values?

formula I'm using:

sum(query(Encoding!$A$4:$K$9,"Select D where (A contains '"&C$2&"') and (B contains '"&C$3&"') and (C = date '"&text($B$4,"yyyy-mm-dd")&"')"))

Sample data is attached,

enter image description here

  • Related