sumifs or ifs formula

[jabbaman]

hello all, i have had help on this before but i have added something new and can't work out the formula

[TABLE="width: 611"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Win Price[/TD]
[TD]Place Price[/TD]
[TD]Win Outlay[/TD]
[TD]Place Outlay[/TD]
[TD]Finished[/TD]
[TD]Win Amount[/TD]
[TD]Place Amount[/TD]
[TD]Won/Lost[/TD]
[/TR]
[TR]
[TD]$4.70[/TD]
[TD]$1.90[/TD]
[TD]$50.00[/TD]
[TD]$50.00[/TD]
[TD]1st[/TD]
[TD]$235.00[/TD]
[TD]$95.00[/TD]
[TD]$235.00[/TD]
[/TR]
[TR]
[TD]$2.60[/TD]
[TD]$1.50[/TD]
[TD]$50.00[/TD]
[TD]$150.00[/TD]
[TD]1st[/TD]
[TD]$130.00[/TD]
[TD]$225.00[/TD]
[TD]$130.00[/TD]
[/TR]
[TR]
[TD]$2.20[/TD]
[TD]$1.30[/TD]
[TD]$50.00[/TD]
[TD]$150.00[/TD]
[TD]1st[/TD]
[TD]$110.00[/TD]
[TD]$195.00[/TD]
[TD]$110.00[/TD]
[/TR]
[TR]
[TD]$4.50[/TD]
[TD]$2.10[/TD]
[TD]$50.00[/TD]
[TD]$50.00[/TD]
[TD]1st[/TD]
[TD]$225.00[/TD]
[TD]$105.00[/TD]
[TD]$225.00[/TD]
[/TR]
[TR]
[TD]$2.60[/TD]
[TD]$1.25[/TD]
[TD]$50.00[/TD]
[TD]$150.00[/TD]
[TD]Unplaced[/TD]
[TD]$130.00[/TD]
[TD]$187.50[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]$3.25[/TD]
[TD]$1.70[/TD]
[TD]$50.00[/TD]
[TD]$100.00[/TD]
[TD]2nd[/TD]
[TD]$162.50[/TD]
[TD]$170.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]$1.85[/TD]
[TD]$1.10[/TD]
[TD]$50.00[/TD]
[TD]$200.00[/TD]
[TD]3rd[/TD]
[TD]$92.50[/TD]
[TD]$220.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]$1.30[/TD]
[TD]$1.10[/TD]
[TD]$50.00[/TD]
[TD]$200.00[/TD]
[TD]1st[/TD]
[TD]$65.00[/TD]
[TD]$220.00[/TD]
[TD]$65.00[/TD]
[/TR]
</tbody>[/TABLE]
At the moment i have in the won/lost column =IF(E2="1st",F2,0)
What i want to put in that column is the win amount + place amount if they finish 1st, 2nd or 3rd
i hope someone can help, thanks

 

[Eric W]

Maybe:

=IF(OR(E2={"1st","2nd","3rd"}),F2+G2,0)

 

[jabbaman]

Hi Eric,
That works great, thanks, but when it is 2nd or 3rd i only need it to add up the place amount only, atm it adds the win as well.
example so if it's 1st i need it to add both win and place and if it's 2nd or 3rd, place amount only in the won/lost column.
Thanks Jason

 

[Eric W]

Try:

=IF(E2="1st",F2+G2,IF(OR(E2={"2nd","3rd"}),G2,0))

 

[jabbaman]

Thank you so much Eric.
It works perfect

Cheers

 

[Eric W]

You're welcome