Combining filters between multiple columns

How to sum filter using conditions in multiple columns

    A      B          C        D
  Ben      1         Tom       1
  Joe      3         Ben       4
  Tom      2         Ben       1

I want to get the sum of B,D where A,C does not equal Joe…basically get everyone’s hours except Joes.

update: f you on the negative score…the system does not let me preview the question before posting…so forced to edit on the fly.

This seems so simple but I have been racking my brain trying to get it to work…maybe an array?

UPDATE: it was as simple as a SUMIF! I’ve used sumif many times lol. Thanks to googlesheetsguy

>Solution :

I haven’t downvoted, but it’s probably because you’re not providing any tested solution except "I’ve racking my brain".

For conditional SUMs you can use SUMIF or SUMIFs:

For example:

=SUMIF(A:A,"<>Joe",B:B)

You can use VSTACK to generate two ranges, or just sum two SUMIF with both possible ranges =SUMIF(...)+SUMIF(...)