Rookie needs a lot of excel help?

[Ptexcel1964]

In cell F6, insert a function that will sum the potential rent (i.e., the total rent if all units are occupied) for theapartment complex in A6. Copy the function down through F10.
Total rent column is E14:E26, occupied (yes or no) column is F14:F26, apartment complex name column is B14:B26, hope this is helpful?

 

[Ptexcel1964]

Do we need more info or can anyone help with this?

 

[shg]

We don't do homework, but will point you in the right direction. See Help for the SUMIF function.

 

[RaviWildcat]

Sounds like SUMIF to me as well - why don't you post what you have so far?

 

[Ptexcel1964]

Understood, direction and understanding of formulas was what I was looking for, got it though, thanks.