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)...