Adding Two monetary columns if a third Column has an "X"

[sailorflavor]

I have an excel spreadsheet that contains three total columns in question. One is "Credit" the other is "Debit" and the third is "C". I have two additional cells that account for Cash and account for the bank account. I want the total cash value from the "Credit" and "Debit" column to be added in the cash cell if there is an "X" in the "C" Column and for it to be counted in the "bank account" column if there is no "X" in the "C" Column. Any and all help for a formula that would do this would be excellent! Thank you in advance.

Rami

 

[Joe4]

Welcome to the Board!

If I understand you correctly, you should be able to use IF statements to do what you want, i.e.

Cash cell formula:

=IF(C2="X",A2+B2,"")

Bank Accountl formula:

=IF(C2<>"X",A2+B2,"")

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming the "C" column only contains "X" or nothing try this

Cash column: =IF(C2="X",SUM(A2:B2),"")
Bank column: =IF(C2="",SUM(A2:B2),"")

 

[sailorflavor]

Welcome to the MrExcel board!

Assuming the "C" column only contains "X" or nothing try this

Cash column: =IF(C2="X",SUM(A2:B2),"")
Bank column: =IF(C2="",SUM(A2:B2),"")

Is there a way for me to send you the excel spreadsheet to look over? Those formulas would work if it was as simple as one line but I have 746 cells built in and I need to keep a running total with money added and money subtracted. I think it would be easier if I somehow shared the spreadsheet with you. Thanks again.

 

[Peter_SSs]

Is there a way for me to send you the excel spreadsheet to look over?

No, this is a public forum so that's not possible - refer #4 of the Forum Rules

Just post a small set of sample data (say 8-10 rows), with the expected results filled in manually, directly here in the forum. My signature block below has a link to information about how to do that.

 

[sailorflavor]

No, this is a public forum so that's not possible - refer #4 of the Forum Rules

Just post a small set of sample data (say 8-10 rows), with the expected results filled in manually, directly here in the forum. My signature block below has a link to information about how to do that.

Okay, I will have to wait until I'm on my home computer and not my Government one in order to do that since it requires a download. Thank you.

 

[Peter_SSs]

The 4th link on the Attachments page does not require a download.

Alternatively, in the Reply window, click 'Go Advanced'
Bottom left of 3rd row of toolbars is 'Table' which you can insert (choose 'full grid' for borders).
After selecting that, if you don't see an actual table, click the top left toolbar icon to get "WYSIWYG"

Then you can achieve something like this:

DR	CR	C	etc
2
	5		66

<tbody>
</tbody>

 

[sailorflavor]

This is the basics of the graph, keep in mind that I have another column for total of both cash and bank account but the Navy is making me track cash and account separately as well as the total balance! The amount "861.67" is the cash I have in hand and the "700.71" is what is available in the bank account. Thanks again for all of your help.

C	Debit (-)	Credit (+)	Cash	Account
		286.82	861.67	700.71
X		132.87
		305.29
X		100.01
	300.00
x	50.00
		415.30
X		279.00
		0.01
X	20.44
X		150.10
		263.42

The 4th link on the Attachments page does not require a download.

Alternatively, in the Reply window, click 'Go Advanced'
Bottom left of 3rd row of toolbars is 'Table' which you can insert (choose 'full grid' for borders).
After selecting that, if you don't see an actual table, click the top left toolbar icon to get "WYSIWYG"

Then you can achieve something like this:

DR	CR	C	etc
2
	5		66

<tbody>
</tbody>

 

[Peter_SSs]

I did ask for the expected results to be included, so if this is not what you want, please do that rather than trying to explain again in words.

Excel Workbook
	A	B	C	D	E
1	C	Debit (-)	Credit (+)	Cash	Account
2			286.82	861.67	700.71
3	X		132.87	994.54	700.71
4			305.29	994.54	1,006.00
5	X		100.01	1,094.55	1,006.00
6		300.00		1,094.55	706.00
7	x	50.00		1,044.55	706.00
8			415.30	1,044.55	1,121.30
9	X		279.00	1,323.55	1,121.30
10			0.01	1,323.55	1,121.31
11	X	20.44		1,303.11	1,121.31
12	X		150.10	1,453.21	1,121.31
13			263.42	1,453.21	1,384.73
Totals