Excel sumif to calcluate all values that are equal to the furthest right value

[Godwin117]

I have this formula, but it isn't working like I want it to. I am looking for it to calculate the sum of the right most value. An example is below.

Sum = 8

based on

|
|
\/
current formula, "=SUMIFS(G:G,F:F, RIGHT(F:F, 1)={2,3,4})"

Column "G" is the 2 column below
Coulmn "F" is the 1 column below

rynssm2	1
ofndns3	5
ookknf2	2
ppjojv1	6

 

[Fluff]

How about

+Fluff.xlsm
	F	G	H	I
2	rynssm2	1		8
3	ofndns3	5
4	ookknf2	2
5	ppjojv1	6
Data

Cell Formulas
Range	Formula
I2	I2	=SUMPRODUCT((RIGHT(F2:F5,1)+0={2,3,4})*(G2:G5))

 

[Godwin117]

How about

+Fluff.xlsm
	F	G	H	I
2	rynssm2	1		8
3	ofndns3	5
4	ookknf2	2
5	ppjojv1	6
Data

Cell Formulas
Range	Formula
I2	I2	=SUMPRODUCT((RIGHT(F2:F5,1)+0={2,3,4})*(G2:G5))

Thank you for the help, it's giving me a #Value!, when I copied and pasted it, not sure why I was getting that error.

 

[Fluff]

You might need to confirm it with Ctrl Shift Enter

 

[Godwin117]

You might need to confirm it with Ctrl Shift Enter

I tried that as well, it'll have to be the whole columns as well.

 

[Fluff]

Do not use whole columns, it will cause your workbook to slow down drastically & could cause incorrect results.
Try it like
=SUMPRODUCT((RIGHT(F2:F5,1)={"2","3","4"})*(G2:G5))

 

[Godwin117]

Do not use whole columns, it will cause your workbook to slow down drastically & could cause incorrect results.
Try it like
=SUMPRODUCT((RIGHT(F2:F5,1)={"2","3","4"})*(G2:G5))

That worked thank you for your help.

 

[Fluff]

You're welcome & thanks for the feedback

 

[jasonb75]

Another way that works with whole columns

=SUM(SUMIFS(G:G,F:F,"*"&{2,3,4}))