Formula that can automatically classify monthly expenses Closed

Question

Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as I am input the data. Thanks
E.g.

Date          Name          classification      amount    travels   training     logistic 
1/1/16          X               travels               200          ?
4/1/16          H                training             500                       ?
6/1/16          G                logistic              500                                    ?
15/1/16         K                travels              600          ?
23/1/16         O               training              900                      ?
30/1/16          S              logistic               300                                    ?




Configuration: Windows 7 / Firefox 44.0

TrowaD · Answer

Hi Nath,

It is unclear to me what you are trying to achieve. Can you show sample data how it is now and how you want it to be, along with steps necessary to get there?

Best regards,
Trowa 
 
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

Formula that can automatically classify monthly expenses

1 response

Similar discussions

Subscribe To Our Newsletter!