Using Google Sheets with the expression SUMIF, is there a way to make the criteria field look for 2 types of values using OR logic?
A B
Joe 1
Joe 2
Tim 3
Roy 4
Tim 5
Roy 6
How do I make a SUMIF to the rows for Joe and Roy so the result is 13? Basically I want it to sum only when cells in A are Joe OR Roy.
Someone showed me how to do it on LibreOffice Calc simply with =SUMIF(A1:A6;"=Joe|Roy";B1:B6), but that doesn't seem to work on Sheets. I've currently resorted to a query like so, =sum(query(A:B,"Select B where A = 'Joe' or A = 'Roy'")), is there a simpler way with just incorporating the pipe |?
Thanks
برچسب:
نویسنده: استخدام کار