managing apartment - how to add all rent for the month

[tonynguyen10]

Hey everyone!

I have spreadsheet that is basically a bank statement. here is what is looks like;

• A1 has the deposit or withdraw
• B1 a drop down menu of it either being a deposit or withdraw
• C1 Year To Date information

On cell C2, all I am trying to do is getting all incoming rent to add up in that cell, C2, so at a glance, i know how much rent I've collected. How can I make this happen? Thank you!

 

[circledchicken]

Hi,

I don't think its completely clear what you want. Can you post a small example with sample inputs and the expected output in C2?

Perhaps this example might help (showing how to sum the deposits):

Excel Workbook
	A	B	C
1	Amount	Type	Year to Date
2	100	Deposit	300
3	200	Withdraw
4	100	Withdraw
5	200	Deposit
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C2	=SUMIF(B:B,"Deposit",A:A)

 

[tonynguyen10]

you hit the nail right on the head - thank you so much!!!! it was exactly what i was looking for. have a good one =)

 

[circledchicken]

Your welcome, thanks for the feedback.