Trouble with SUMIFS. Please help!

[mrsbez]

Hi. I'm new here, and I'm wondering if anyone can help me. I have tried several SUMIFS, and nothing is working for me. I am trying to get the sum (from another worksheet, named Jan) for column J (which is made up of all numbers), but ONLY when ALL 3 of the following criteria are met: Column D says Domestic; E says Chargeback, G says Visa.

Here is one of the formulas I have tried:
=SUMIFS((Jan!J4:J50),(Jan!D4:D50="Domestic"),(Jan!E4:E50="Chargeback"),(Jan!G4:G50="Visa"))

Any suggestions, Please, Please!?!?

 

[VoG]

Try

=SUMIFS(Jan!D4:D50,"Domestic",Jan!E4:E50,"Chargeback",Jan!G4:G50,"Visa")

 

[VaraK]

Hi,

Welcome to the board!
Try this:

=SUMIFS(Jan!J4:J50,Jan!D4:D50,"Domestic",Jan!E4:E50,"Chargeback",Jan!G4:G50,"Visa")

Hope this helps.

 

[mrsbez]

Thank you VaraK and VoG. But those didn't work either. Although they are formulas I had already tried, I tried them again, cut/paste exactly what you guys had for me...no go!

For =SUMIFS(Jan!D4:D50,"Domestic",Jan!E4:E50,"Chargeback",Jan!G4:G50,"Visa") I get "The formula you typed contains an error."

For =SUMIFS(Jan!J4:J50,Jan!D4:D50,"Domestic",Jan!E4:E50,"Chargeback",Jan!G4:G50,"Visa") I get "You've entered too few arguments for this function."

I do have drop menus in some of the columns (for example; D has a drop menu to delect from Domestic or international) Do you think that the drop menus would be the downfall of the formulas I try? I'm so frustrated! Thanks for your suggestions.

 

[Haseeb Avarakkan]

Hello, try

=SUMIFS(Jan!J4:J50,Jan!D4:D50,"Domestic",Jan!E4:E50,"Chargeback",Jan!G4:G50,"Visa")