I want to add values in Column C with the conditions that
Column B = 0, AND
Column A = "a" OR "b"
From what I've searched, this would work, but only in excel:
I've tried adding "ArrayFormula" as this is a supposedly 'fix' for the above formula for Google Sheets (but tbf, I've only seen it used in COUNTIFS not SUMIFS)
My expected result should be 4 but it keeps on returning 1. Weirdly, if I switch "a" and "b", it would return 3. As if it doesnt take the second criteria into account.
Ive been searching for days now, any help would be appreciated!