186 reputation
3
bio website spreadsheetsmadeeasy.com
location Florida
age
visits member for 1 year, 9 months
seen Apr 7 at 17:26

Feb
10
comment how do I add isblank(ref) criteria to arrayformula?
@JacobJanTuinstra, About returning one value, yes, that was my intention. I thought the OP's requested to do a sum based on his conditions, which I thought he meant to return the sum only, not the rows that match. BTW, +1 to your answer. I had no clue Google Spreadsheets could do queries like that
Feb
10
comment how do I add isblank(ref) criteria to arrayformula?
@JacobJanTuinstra, good point. Thanks for letting me know. I have fixed the error.
Feb
10
comment how do I add isblank(ref) criteria to arrayformula?
so, when you say "When F matches C" do you mean in the same row? Or do you mean when C's value is found in F?