Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/VLOOKUP between multiple worksheets | Excel Worksheet Functions | |||
Vlookup using multiple worksheets | Excel Discussion (Misc queries) | |||
Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
Vlookup multiple worksheets | Excel Worksheet Functions | |||
vlookup over multiple worksheets | Excel Worksheet Functions |