EXCEL FUNCTION

I have applied the ate attached function which is simply to apply sumifs to those cells in a column that meet a condition obtained by applying the RIGHT function to the cells in the column.
However all that comes back is a value of 0 .
What have I done incorrectlySUMIFS-WITH-RIGHT.xlsx

SUMIFS(B3:B9,A3:A9,RIGHT(A3:A9,6)="EXTELP")
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You might need an additional column for this.
If you use an extra column C and in C3 the following formula:
=RIGHT(A3,6)
and then copy this formula down to C9. Then change the formula in B11 to:
SUMIFS(B3:B9,C3:C9,"EXTELP")
0
Commented:
Use an array formula
=SUM(IF(RIGHT(A3:A9,6)="EXTELP",B3:B9,0))
Insert in cell with Ctrl+Shift+Enter, and Excel enclose the formula in {} brackets.

or use Sumproduct
=SUMPRODUCT(--(RIGHT(A3:A9,6)="EXTELP"),B3:B9)
0

Experts Exchange Solution brought to you by