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 for the rows that have Joe and Roy so the result is 13?
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 |?