VLookUp Sum?

[skip08]

I'm working on a table here where I need to work out the sum of the rent from apartments during a set month.

In the first sheet, I'll have all of the information about the rent paid, client etc, and on the second, a sort of summary listing the amount of money earned in rent by each apartment each month.

I know there is a vlookup in here somewhere, which I have tried including on the formula you can see on my second sheet in attachment.

I haven't been able to add in the 'sum' element, nor the fact that it must continue to include future reservations.

The most difficult part is making this formula take into account additional, unanticipated reservations we may get near the end of the month and have the range still increase as rows are added.

Any help provided would be greatly appreciated.

Kindest regards,

skip08

[Bob Phillips]

Just use SUMIF

=SUMIF(Feuil1!$C:$C,Feuil2!C4,Feuil1!$D:$D)

[skip08]

Just use SUMIF

=SUMIF(Feuil1!$C:$C,Feuil2!C4,Feuil1!$D:$D)

You have no idea the trouble you have saved me. I tried SumIf once as well, but the french terms confused me. -__-``.

Thanks again Bob!