If a cell cointains a specific name, then the value...

Closed
heronramos Posts 1 Registration date Saturday March 29, 2014 Status Member Last seen March 29, 2014 - Mar 29, 2014 at 04:25 PM
 Blocked Profile - Mar 29, 2014 at 05:40 PM
Hi!

I'm really new (dumb) when it comes to using excel and I've been trying to make my expenses spreadsheets more functional.
Here's the layout?

A column = type of expense
B column = date
C column = details of that expense
D column = payed in credit
E column = payed in debit

The formula I'm trying to come up with is this:

If A2 column says FOOD (or one of the 10 other categories I've created), then check on D2 and E2 (meaning the same row) for value and ADD those values on E92 (in this case, the FOOD sum of all related expenses).
It should be checking for the category on the first column, then looking for values on D and E, and getting those values added to the corresponding category sum up cell.

Does that make sense? Is it possible?

Thanks in advance!

1 response

Blocked Profile
Mar 29, 2014 at 05:40 PM
Ok, well I wasn't certain how you wished to trigger this, so I wrote it like this:



If you have any questions, let us know. By the way, you could have a place on the expense report for "professional Services". Make the payment to paypal account.....Oh just kidding!

Have FUN!

"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
0