I need to RIGHT(VALUE,2)<>"00" inside a SUMIFS statement

[aronlmin]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Cost Code[/TD]
[TD]Type[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]1000-00[/TD]
[TD]FIELD[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]1000-00[/TD]
[TD]SHOP[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]1000-02[/TD]
[TD]FIELD[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]1000-03[/TD]
[TD]SHOP[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

I need to do a sumifs statement for anything "Type" of "FIELD" and it must exclude any "Cost Code" ending in "00"

I have looked online and have not found any examples for using the LEFT, RIGHT, or MID methods within a SUMIFS statement

the correct answer should result in 3

In essence it im trying to figure out something like...
=SUMIFS(C2:C5,B2:B5,"FIELD",A2:A5,RIGHT(???,2)<>"00")


thanks

 

[Rick Rothstein]

This seems to work...

=SUMIFS(C2:C5,A2:A5,"<>*00",B2:B5,"FIELD")

 

[aronlmin]

This seems to work...

=SUMIFS(C2:C5,A2:A5,"<>*00",B2:B5,"FIELD")

worked perfect, thank you!