Excel Gurus - ROSS MAY BE THE MAN!

[Brettles1986]

I have separate worksheets for each month of the year and in those worksheets are numbers against each person for each day. Each month the amount of people is not the same.

How can I sum the values of each month in a summary page but only for a particular individual (if that makes sense).

I have experimented with Vlookups but I would need a hell of a lot for it to work.

[rey]

Google's answer:

Finding the sum in this situation is simple. You can use a formula:

Start Excel. A new, blank workbook appears.
1. In cell B3 in Sheet1, type 20.
2. In cell B3 in both Sheet2 and Sheet3, type 30.
3. In cell A1 in Sheet1, type the following formula:
=SUM(Sheet1: Sheet3!B3) *NO SPACE BETWEEN : & S*
4. Press ENTER. Notice that cell A1 displays 80, which is the total sum of the cells in the three worksheets.

Found here: Link

EDIT:

Just tried it and it works, also works for renamed sheets.

[Brettles1986]

Originally Posted by rey

Google's answer:



Found here: Link

EDIT:

Just tried it and it works, also works for renamed sheets.

That's the simple part, I need it to check the values in each sheet and only return the ones that have that persons name in the left most column of the range.

For example:

Brett - Sheet 1 = 30
Brett - Sheet 2 = 30
Brett - Sheet 3 = 40
Brett - Sheet 4 Total = 100

However, the list are not the same time and in the same order each time.

[rey]

How about this: Link

[Brettles1986]

Originally Posted by rey

How about this: Link

I'll check that out, looks like it might help me although I need to search for the name in each worksheet as well summing the corresponding values.

Cheers

[e8_pqck]

what went wrong with VLOOKUP, i use it all the time.

You can also add more commands, i used to use IF aswell as various other logic functions.

[e8_pqck]

SUMIF will add cells in a range.

=SUMIF(K7:Q24,"BRETT",Q7:Q24)

I think SUMIFS if using multiple sheets may work.