VLOOKUP - Multiple Worksheets
 

I have to generate a report that references data from 3 Worksheets, all 3
worksheets are identical and the coloumns will not change, however new rows
and data is added regulary.

I need to Sum all the numerical values in column F from each of the three
worksheets that reference to specific Text fields (i.e "Student", "Teacher")
in column B.

The worsheets have numerous blank cells but the text is is consistent as it
is generated from a drop down menu.

Any help is greatly appreciated...

VLOOKUP - Multiple Worksheets
 

Put the names of the three sheets in M1:M3 and use

=SUMPRODUCT(SUMIF(INDIRECT("'"&M1:M3&"'!B1:B100"), "Teacher",INDIRECT("'"&M1:
M3&"'!F1:F100")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kate" wrote in message
...
I have to generate a report that references data from 3 Worksheets, all 3
worksheets are identical and the coloumns will not change, however new
rows
and data is added regulary.

I need to Sum all the numerical values in column F from each of the three
worksheets that reference to specific Text fields (i.e "Student",
"Teacher")
in column B.

The worsheets have numerous blank cells but the text is is consistent as
it
is generated from a drop down menu.

Any help is greatly appreciated...