if cell contains two different specific texts then return two different values

stevie_c

New Member
Joined
Nov 15, 2018
Messages
2
im looking for a formula that returns two seperate values based on two different texts in other columns

e.g

£10£15
ProductCost
Windows10
Windows & Doors15
Windows10

<tbody>
</tbody>

I then need to be able to sum the total cost

Thanks
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

KolGuyXcel

Board Regular
Joined
Jun 29, 2018
Messages
128
Is it something like this?

=IF(A1="Windows",10,if(A1="Windows & Doors",15,""))

And then to get the sum (Adjust the range $B$1:$B$3 accordingly)

=SUMIF($A$1:$A$3,"Windows",$B$1:$B$3) etc.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,512
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top