Cant get SUMIFS to work for multiple criteria?

[tahir9]

Essentially my function looks like this on another worksheet. SUMIFS(INDEX(TEXAS!$A$5:$ER$5000,,MATCH(B$2,TEXAS!$A$4:$ER$4,0)),TEXAS!$L$5:$L$5000,"<>3",TEXAS!$AP$5:$AP$5000,"<>Does Not Use Casher"). B2 is the column header for the column I want the sum of. L is a column in another sheet that I want to evaluate and make sure its not three, and AP is the other column I want to evaluate where I want it to skip all the does not use casher. I also have other things I want to add on but currently I just want it to work with these criteria...

 

[NeonRedSharpie]

What is the problem that you are experiencing? For starters I see a double comma before the match function.

 

[barry houdini]

Hello tahir9, welcome to MrExcel

That formula looks good to me - what problem do you have, are you getting an error or the wrong result

 

[tahir9]

Fixed it was essentially my rows going too far down and I was getting the sum added to what the formula was giving me. Thanks for the feedback!

 

[shakeel_1215]

[h=1]can i make sheet name as criteria in SUMIFS plz reply now[/h]

 

[Aladin Akyurek]

can i make sheet name as criteria in SUMIFS plz reply now

Now? Please try to be a bit patient...

A2 houses a sheet name like TEXAS.

=SUMIFS(
  INDEX(INDIRECT("'"&$A2&"'!A5:ER5000"),0,
     MATCH(B$2,INDIRECT("'"&$A2&"'!A4:ER4"),0)),
  INDIRECT("'"&A2&"'!L5:L5000"),"<>3",
  INDIRECT("'"&A2&"'!AP5:AP5000"),"<>Does Not Use Casher")