joseph4tw

186 reputation

	186 reputation	bio	website	spreadsheetsmadeeasy.com	visits	member for	5 months
3 badges		location	Florida		seen	May 1 at 21:25

10 Actions

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