186 reputation
3
bio website spreadsheetsmadeeasy.com
location Florida
age
visits member for 1 year, 8 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
awarded  Editor
Feb
10
revised how do I add isblank(ref) criteria to arrayformula?
changed formula to match OP's request
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
answered how do I add isblank(ref) criteria to arrayformula?
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?
Feb
5
answered Min/Max of a row only if value in other row is X
Dec
18
awarded  Supporter
Dec
16
awarded  Teacher
Dec
12
answered Counting unique rows in spreadsheets