Help please sum formula to sum based on conditions

[mina91709]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]OIGINAL AMOUNT[/TD]
[TD]REV1[/TD]
[TD]REV2[/TD]
[TD]REV3[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]150[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]300[/TD]
[TD]800[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]150[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]60[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

I need a formula to sum all based on the latest value entered from the example above it will pick up
200 for row a
50 for row b
300 for row c
50 for row d
50 for row e
7 for row f
total should be 657

thank you very much

 

[mina91709]

This is a great solution thank you very much AlphaFrog ?

 

[AlphaFrog]

You're welcome. Thanks for the feedback.

 

[mina91709]

You're welcome. Thanks for the feedback.

Thanks again. I have another challenge and would love to see if you can help me out. I used your formula but now, I would like to add another restriction:
NOW I WOULD LIKE TO ADD THE LATEST INPUT BASED ON STATUS FROM THE EXAMPLE BELOW
FOR PENDING THE TOTAL SHOULD BE:500+30+80=610
FOR APPROVED THE TOAL SHOULD BE:50
FOR REJECTED THE TOTAL SHOULD BE:40
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]original[/TD]
[TD]rev1[/TD]
[TD]rev2[/TD]
[TD]rev3[/TD]
[/TR]
[TR]
[TD]approved[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]300[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD]500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rejected[/TD]
[TD]90[/TD]
[TD]50[/TD]
[TD]300[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]20[/TD]
[TD]80[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I REALLY APPRECIATE ALL YOUR HELP THANK YOU

 

[AlphaFrog]

Try this...
=SUMIF(A:A,"Pending",E:E)+SUMIFS(B:D,A:A,"Pending",C:E,"")

 

[mina91709]

Try this...
=SUMIF(A:A,"Pending",E:E)+SUMIFS(B:D,A:A,"Pending",C:E,"")

Thank you for fast response AlphaFrog. For some reason it didn't work. Would you please take a look at my excel file and let me know. It's in the dropbox link below.

Thank you
https://www.dropbox.com/s/6ywkl8sn3a9ruln/TEST.xlsx?dl=0

 

[AlphaFrog]

Try these...

=SUMPRODUCT((A2:A10="Approved")*((B2:B10*(C2:C10=0)+(C2:C10*(D2:D10=0)+(D2:D10*(E2:E10=0)+E2:E10)))))

=SUMPRODUCT((A2:A10="Pending")*((B2:B10*(C2:C10=0)+(C2:C10*(D2:D10=0)+(D2:D10*(E2:E10=0)+E2:E10)))))

=SUMPRODUCT((A2:A10="Rejected")*((B2:B10*(C2:C10=0)+(C2:C10*(D2:D10=0)+(D2:D10*(E2:E10=0)+E2:E10)))))

 

[Aladin Akyurek]

Thanks again. I have another challenge and would love to see if you can help me out. I used your formula but now, I would like to add another restriction:
NOW I WOULD LIKE TO ADD THE LATEST INPUT BASED ON STATUS FROM THE EXAMPLE BELOW
FOR PENDING THE TOTAL SHOULD BE:500+30+80=610
FOR APPROVED THE TOAL SHOULD BE:50
FOR REJECTED THE TOTAL SHOULD BE:40
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]original[/TD]
[TD]rev1[/TD]
[TD]rev2[/TD]
[TD]rev3[/TD]
[/TR]
[TR]
[TD]approved[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]300[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD]500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rejected[/TD]
[TD]90[/TD]
[TD]50[/TD]
[TD]300[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]pending[/TD]
[TD]20[/TD]
[TD]80[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I REALLY APPRECIATE ALL YOUR HELP THANK YOU

[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD][/TD]
[TD]original[/TD]
[TD]rev1[/TD]
[TD]rev2[/TD]
[TD]rev3[/TD]
[TD]lvalue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]approved[/TD]
[TD]

100​

[/TD]
[TD]

200​

[/TD]
[TD]

300​

[/TD]
[TD]

50​

[/TD]
[TD]

50​

[/TD]
[TD][/TD]
[TD]approved[/TD]
[TD]

50​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]pending[/TD]
[TD]

300​

[/TD]
[TD]

200​

[/TD]
[TD]

500​

[/TD]
[TD][/TD]
[TD]

500​

[/TD]
[TD][/TD]
[TD]pending[/TD]
[TD]

610​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]rejected[/TD]
[TD]

90​

[/TD]
[TD]

50​

[/TD]
[TD]

300​

[/TD]
[TD]

40​

[/TD]
[TD]

40​

[/TD]
[TD][/TD]
[TD]rejected[/TD]
[TD]

40​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]pending[/TD]
[TD]

30​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

30​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]pending[/TD]
[TD]

20​

[/TD]
[TD]

80​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

80​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In F2 enter and copy down:

=LOOKUP(9.99999999999999E+307,B2:E2)

In I2 enter and copy down:

=SUMIFS($F$2:$F$6,$A$2:$A$6,H2)