If cell equals "Y" then insert the contents of another cell

**Ampmeister** · 03-27-2013, 09:14 AM

Hi,

I have a simple table for mileage and the costs are either to be charged to one company or another.

The table has the following 6 headers:

Date->Total miles->Client 1->Client 1 formula->Client 2->Client 2 formula

I insert the total miles for the trip in the total miles column and then insert a Y under either Client 1 or Client 2, depending on which client it is to be charged to.

Ideally I want a formula for the "Client 1 formula" column that says if the Client 1 cell equals "Y" then insert the number of miles shown in the corresponding "Total miles" column

I will then hide the column and do a summary stating number of miles for Client 1 and number of miles for Client 2.

Thanks x

**etaf** · 03-27-2013, 09:27 AM

=IF(client1cell ="Y", cell for totalmiles , "")

assuming setup as

Date->Total miles->Client 1->Client 1 formula-
A2>B2>C2>D2

in D2
=IF(C2="Y", B2,"")

you could use SUMIF
=SUMIF(C2:C4,"Y",B2:B4) for client 1 and then

=SUMIF(E2:E4,"Y",B2:B4) for client 2 assuming Y is in E column for that client

saves the extra column and will do the total in one go

you could go 1 step further and then in your column for which client put
client1
or
client2

and then use two sumif and use the criteria of client1 or client2 to add the totals
=SUMIF(C2:C4,"client1",B2:B4)
=SUMIF(C2:C4,"client2",B2:B4)

**nawas** · 03-27-2013, 09:29 AM

Assuming total miles in Cell B2, Client 1 in Cell C2 , Client 2 in Cell D2

In Client 1 formula :

Please Login or Register  to view this content.

is that you mean?

**Tony Valko** · 03-27-2013, 09:29 AM

Try this...

Let's assume the column headers are in the range A1:F1.

Enter this formula in D2:

=IF(C2="Y",B2,"")

Enter this formula in F2:

=IF(E2="Y",B2,"")