Formula to link a value to another cell depending on a given statement

**zachncolorado** · 07-19-2012, 12:13 AM

I am trying to use the IF function (not sure if this is possible) in order to accomplish the following...

If A1 is X then B1=C1+C2, If A1 is Y then B2=C1+C2, If A1 is Z then B3=C1+C2

I can make my sheet work if I can accomplish the above....However, it would be even better if I could get the following to work

D1 is the sum of all the values in X category, D2 is the sum of all the values in the Y category and so on

Basically I have a spending sheet with deposits and withdraws and I am using a drop down menu (to save space) to specify the category of the deposit or withdraw (i.e Bills, savings). Then I would like a total after all deposits and withdraws per category. I could simplify the deposit withdraw by simply making the value positive or negative, but I would also like a total withdraw and total deposit value as well.

Thanks for the help!

**jeffreybrown** · 07-19-2012, 12:37 AM

Have you looked into using =SUMIF(range,criteria,sum_range)

**zachncolorado** · 07-19-2012, 09:56 AM

I couldn't get the SUMIF function to work for me, but I just used the IF function like so..

=IF(G3="Available (44%):",SUM(H3:I3),IF(G3="Bills (33%):",SUM(H3:I3)))

BUT, I still need a way to get the value to another cell. Is that possible? For example... something like this...

=IF(G3="Available (44%):",K28=SUM(H3:I3),IF(G3="Bills (33%):",K27=SUM(H3:I3)))

Although I know the above won't work.

**jeffreybrown** · 07-19-2012, 12:17 PM

If I'm understanding this correctly, why not just have a separate formula in K28, K27 etc.,

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

This is just one thought, but if this doesn't work then a sample workbook would help.

**zachncolorado** · 07-19-2012, 04:47 PM

Yeah I realized that earlier. I can make it work with that formula, I will just have to use a seperate sheet for calculations...which may fill up fast.

If at all possible it would be nice to bypass the need for an extra sheet. To clarify, I made a sample of the workbook with random numbers. This includes the correct IF function and the calculation sheet. The focus here is on the "Specific Modifications" Table and the "Overview" Table.