I have a bunch of worksheets showing rental income data across four
different cities. Within each city there are about eight (8) different
real estate types (ie 1 bedroom, 2 bedroom etc.).

How can I calculate an average (in a new worksheet) of a specific real
estate type across the four cities when the respective data ranges in
each city do not appear in the same rows in each worksheet? However,
the ranges will be in the same columns across each worksheet.
Furthermore, in a different column on each worksheet will be the name
of the 'real estate type' which is consistent across all cities.
Basically, I am trying to capture the relevant rental income range in
each city where each range corresponds to the same real estate type,
and then take an average of that entire range.

If this does not make sense please let me know - and thanks in
advance...

Regards
Pelham Higgins

test

Pelham wrote:
I have a bunch of worksheets showing rental income data across four
different cities. Within each city there are about eight (8) different
real estate types (ie 1 bedroom, 2 bedroom etc.).

How can I calculate an average (in a new worksheet) of a specific real
estate type across the four cities when the respective data ranges in
each city do not appear in the same rows in each worksheet? However,
the ranges will be in the same columns across each worksheet.
Furthermore, in a different column on each worksheet will be the name
of the 'real estate type' which is consistent across all cities.
Basically, I am trying to capture the relevant rental income range in
each city where each range corresponds to the same real estate type,
and then take an average of that entire range.

If this does not make sense please let me know - and thanks in
advance...

Regards
Pelham Higgins

Try getting something to work in the SAME file first - maybe on a new sheet
Without more detail on layout, try something like
=(SUMIF(Sheet2!D10:D15,"1 bedroom",Sheet2!F10:F15)+SUMIF(Sheet3!D10:D15,"1
bedroom",Sheet3!F10:F15) )/(COUNTIF(Sheet2!D10:D15,"1
bedroom")+COUNTIF(Sheet3!D10:D15,"1 bedroom"))
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pelham" wrote in message
oups.com...
test

Pelham wrote:
I have a bunch of worksheets showing rental income data across four
different cities. Within each city there are about eight (8) different
real estate types (ie 1 bedroom, 2 bedroom etc.).

How can I calculate an average (in a new worksheet) of a specific real
estate type across the four cities when the respective data ranges in
each city do not appear in the same rows in each worksheet? However,
the ranges will be in the same columns across each worksheet.
Furthermore, in a different column on each worksheet will be the name
of the 'real estate type' which is consistent across all cities.
Basically, I am trying to capture the relevant rental income range in
each city where each range corresponds to the same real estate type,
and then take an average of that entire range.

If this does not make sense please let me know - and thanks in
advance...

Regards
Pelham Higgins