Sumif with data validations for Google Sheets

[YupImHere]

I have tried all that I could find on this site. What I am trying to do is Sumif the colums:
Column E,Owner, uses dropdown
Coumn F is the the amount paid: =IF(E20="Ian","$.50","")
Column G,Payment,I want to total all of Column F:
I have: =sumproduct(sumif($E2:$E49,"-ian",$F2:$F49))
also have tried: =sumif(E2:E49,"Ian",F2:F49)
All i ever return are 0, column G is what i need help with

 

[Fluff]

Is this for Excel or Google sheets?
The reason you get 0 is the values in col F are text & not numbers.

 

[YupImHere]

Is this for Excel or Google sheets?
The reason you get 0 is the values in col F are text & not numbers.

Google Sheets, that I am using in Appsheet
The format for col F is number

 

[Fluff]

In that case you should post such questions in the General Discussion & Other Applications section of the board & make it clear what you are actually using.
I have done that for you this time.

 

[Fluff]

The cell format is irrelevant, the actual value is text as the formula is returning text.
You would need to use

=IF(E20="Ian",0.50,"")

 

[YupImHere]

The cell format is irrelevant, the actual value is text as the formula is returning text.
You would need to use

=IF(E20="Ian",0.50,"")

I cant believe how silly i feel I didnt see this. Thank you so much! Works just how I wnated it to!!

 

[Fluff]

You're welcome & thanks for the feedback.