Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF Function to get data from several worksheets
I use the following formulas to bring in data from other worksheets in a
workbook. Currently each formula brings the data into a separate cell on sheet 4. I would like to combine all three formulas to bring the data into one cell instead of three indivudal cells. How can this be done? =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) =SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) =SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF Function to get data from several worksheets
One way:
=SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) + SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) + SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) for other ways, see http://www.mcgimpsey.com/excel/threedsumif.html In article , Kazmaniac wrote: I use the following formulas to bring in data from other worksheets in a workbook. Currently each formula brings the data into a separate cell on sheet 4. I would like to combine all three formulas to bring the data into one cell instead of three indivudal cells. How can this be done? =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) =SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) =SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) Thank You |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF Function to get data from several worksheets
Thank You! One note though....In order to get the formula to work I had to
change the names of the work sheets so there were no spaces in the name and then modified the formulas to also remove the space in the worksheet names. Once I removed the space the formula worked. Once again - thank You. "JE McGimpsey" wrote: One way: =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) + SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) + SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) for other ways, see http://www.mcgimpsey.com/excel/threedsumif.html In article , Kazmaniac wrote: I use the following formulas to bring in data from other worksheets in a workbook. Currently each formula brings the data into a separate cell on sheet 4. I would like to combine all three formulas to bring the data into one cell instead of three indivudal cells. How can this be done? =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) =SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) =SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) Thank You |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF Function to get data from several worksheets
I used your individual formulas without paying attention to the spaces.
You could also have put single quotes around the sheet names: =SUMIF('Sheet 1'!D:D,"Your Name",'Sheet 1'!E:E) + ... In article , Kazmaniac wrote: Thank You! One note though....In order to get the formula to work I had to change the names of the work sheets so there were no spaces in the name and then modified the formulas to also remove the space in the worksheet names. Once I removed the space the formula worked. Once again - thank You. "JE McGimpsey" wrote: One way: =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) + SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) + SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) for other ways, see http://www.mcgimpsey.com/excel/threedsumif.html In article , Kazmaniac wrote: I use the following formulas to bring in data from other worksheets in a workbook. Currently each formula brings the data into a separate cell on sheet 4. I would like to combine all three formulas to bring the data into one cell instead of three indivudal cells. How can this be done? =SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E) =SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E) =SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E) Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF across multiple worksheets | Excel Discussion (Misc queries) | |||
Sumif Across multiple worksheets | Excel Worksheet Functions | |||
SUMIF across worksheets | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
I WANT TO USE THE SUMIF FUNCTION WITH DATA SERIES MORE THAN ONE C. | Excel Worksheet Functions |