Trying to assign subtotal to a specific cell by keyword

[lumbernuts]

Hi, I currently have to manually put the subtotal in the proper category, how would i do the following so if for example it sees "FREEDOM MOBILE" in the description it would automatically assign it to "Cell Phone" column. Thanks.

Bank Bank Bank GST GST Source deduction Corporate Corporate Vehicle Ford Credit Heavy Heavy Equip Insurance for Heavy Equip Tool Cell Office Lic, Dues Work Description Withdrawals Deposits Balance Revenue Collected ITC's arrears/penalty GST Payment Subtotal Calculation Income Tax Payment(provincial) Income Tax Payment(federal) Expenses Payment Equip Hauling Heavy Equip Maintainence Fuel Supplies Tools Phone Service Expenses Mem. Clothes Cell Phone Balance Forward $ - $ - $ - $ - FREEDOM MOBILE $ (61.90) $ - $ - $ 2.95 $ (58.95) 58.95 $ 58.95

 

[lumbernuts]

I had the cell # off by one but it still gives me the same error

 

[lumbernuts]

Excel 2013 has it as "logical test" and then sheets has it as "logical expression"

 

[lumbernuts]

I finally got it ! by using this formula, =IF(C27="FREEDOM MOBILE",L27,0) but you def led me down thr right path thx !

 

[fjns]

Hi, try this formula in Excel 3013
=IF(C26="FREEDOM MOBILE",L26,"")

 

[fjns]

The formula changes automatically after downloading
from =IF(C26="FREEDOM MOBILE";L26;"")
to =IF(C26="FREEDOM MOBILE",L26,"")

 

[lumbernuts]

Now if I want to add multiple keywords to the formula, how could i do that? Ive tried using comma, semi colon, quotations

 

[fjns]

The formula is for 3 more keywords
=IF(OR(C26="FREEDOM MOBILE",C26="KEYWORDS1",C26="KEYWORDS2",C26="KEYWORDS3"),L26,"")

 

[lumbernuts]

Yes I got it working beautifully now thx so much!

 

[fjns]

Hi, I am very glad that the formula works.
If I have enough knowledge, I am happy to help at any time.