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

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

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

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