Sum specific amount if cell contains certain value

[Taggit89]

Hello to all,

First post in the forum and I need HELP!

Is there a formula that can sum a specific amount if a cell contains a certain value?

Example:

Apple =SUMIF(A1,”Apple”,500) would return 500

Apple, Banana, Oranges =SUMIF(A3,”Apple”,500)&SUMIF(A3,”Banana”,500)&SUMIF(A3,”Oranges”,500) would return 1500

Thanks in advance!

 

[Taggit89]

I just realized the & would string the amounts together, yes I would put + instead. Obviously.

 

[FDibbins]

I presume you mean for this to apply to a range, not just A1?
try this...
=SUM(sumIF(A1:A1000,{"Apple","Orange","banana"}))

If you just want to test for A1, then you dont need the SUM...
=IF(Or(a1="apple',A1=Banana",A1="Orange),500,0)

 

[Taggit89]

This would only be for A1

Also the different values would equal different amounts so I wouldn't be able to set everything to 500. My bad on not posing that differently in my example. Here is what I came up with:

=IF(ISNUMBER(SEARCH("*apple*",A1)),SUM(500))+IF(ISNUMBER(SEARCH("*banana*",A1)),SUM(500))

I have multiple products that I need to easily price listed within one cell and I'll be copying the formula down to price each cell in the column.

Think of this as pricing a basket of groceries. I have to know the total price of each basket individually.

I'm hoping this works, thank you for your help!

 

[FDibbins]

Confused

Would A1 contain both Apple AND banana, or just 1 or those?
If only 1, then you could still use something like...
=SUM(sumIF(A1,{"Apple","Orange","banana"},500))