View original (French)

Excel IF(LEFT or RIGHT)

Solved
la salette Posted messages 28 Status Member -  
la salette Posted messages 28 Status Member -
Hello,

Here is my problem. I have an Excel 2010 table:

A B C
trip to Lyon 12.00
travel to Lyon 23.00
accompaniment to Lyon Jean 45.00
supermarket Lyon for 3 70.00

When the col. A contains "Lyon," I would like to copy the amounts from col. B to col. C

Thank you for your help.

Configuration: Windows 7 / Chrome 30.0.1551.0

5 answers

Answer 1 / 5
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 743
 
Hello,

With this formula: 

=SUMPRODUCT((FIND("Lyon",A1:A4)>0)*B1:B4)

--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
0