Using SUMIF Function to get data from several worksheets

K

Kazmaniac

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
 
K

Kazmaniac

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.
 
J

JE McGimpsey

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) + ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top