SUMIF with 1 range, 1 criteria, but multiple sum ranges

[TheIowaKid]

I have spent over an hour looking for a solution and cannot find one so I apologize if this has been answered before. It seems like it should have, but I couldnt find a solution posted. I want to use SUMIF with one range, one criteria which is text, and multiple sum ranges that are not adjacent to each other. Here is what I have tried to use, which of course will not work:

=SUMIF(B2:B21,"Fake Name",(E2:E21,H2:H21,N2:N21,T2:T21,Z2:Z21,AC2:AC21,AF2:AF21,AI2:AI21,AO2:AO21,AQ2:AQ21,AS2:AS21,AY2:AY21,BA2:BA21,BC2:BC21,BE2:BE21,BG2:BG21,BI2:BI21,BK2:BK21,AS2:AS21))

Here is a smaller scale example with the solution I tried and failed. Note that I dont want to do multiple SUMIFS as you can see there are A LOT of ranges.

SUMIF(A2:A6, "Fake Name",(B2:B6, D2:D6, E2:E6)) (this or course does not work, what will?)

Basically if A2:A6 contains the text "Fake Name" Then I would like to add the corresponding sum ranges.

Name Rejected NIGO Rejected IGO Rejected Mnt Rejected
Fake Name 8 5 3 2
Fake Name 6 3 7 0
Same Name 8 5 3 2
Fake Name 1 7 2 9
Same Name 8 5 3 2



Hopefully I have provided enough info here to get someone started! Excel is some fun stuff actually! Thanks for any help that can be provided.


EDIT: I noticed that my data was crunched but it should have 6 rows with 5 columns.

 

[Jonmo1]

The ones that return "" would be a problem, that is not actually blank, it's a text value.

Try making those return 0 instead of "", there are other ways to hide the zeros if you must.

 

[Edward Sky]

You my friend are a god! Thank you

 

[Jonmo1]

You're welcome.