Sum if name = name?

[neilpateluk]

Hi,

This may be a stupid question but :

I have a sheet with tabs for each month. Each month has a list of people names and their results next to them for each week.

I then have a summary sheet that I require to plus all the weekly averages over each sheet for a year to date table.

What I need is a formula that will say something like if the name in the summary sheet is the same as the name in the Jan sheet then plus every 3rd column.

I can't use a pivot table as the data has to be shown in a certain way.

[neilpateluk]

I think I may have found a way to do this:

SUMIF('January 09'!$B$7:$B$26,'Year To Date'!C17,(OFFSET('January 09'!$F13,0,(COLUMNS($C17:D17)-1)*4)))

However, this doesn't quite work, as it seems to skip a row each time... but i don't know why???

[NBVC]

Try something like:

Please Login or Register  to view this content.

Where you data in Jan 09 sheet is located in B2:X100 (column B is names to match to C17)