[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
<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
Last edited: