How to check how many tenants were in a house at a specific date

[tomca]

Hi everyone,

I am looking to determine a fair share of bills for a sharehouse where a lot of people come and go at various different times and bills are issued many months after the fact. It would therefore be very useful to determine how many people were in the house at one time so we can split bills.

I'd be really grateful if someone could suggest how to do this using formula, as I can't work out a way to do this without doing it manually.

Thank you

Tom

[JieJenn]

Assuming your dates criteria are inclusive, you can use the COUNTIFS function. in C1 enter this formula and fill the formula down
=COUNTIFS($D$5:$D$10,"<="&A17,$E$5:$E$10,">="&A17)

[tomca]

Thank you - this works perfectly