Sumif of particular column

[hedgie]

List of personnell in column A. Column B are valuse for 1/1/11, Column C is for 2/1/11 etc...

On another sheet I want to sum the totals for a person in Column A, based on a particular date that is defined in a cell on this new sheet. I know I can use Match to find which column number the summing needs to take place, but I am having problems with the syntax to then incorporate the right column into the sumif formula.

Ideas?

 

[Matty]

Hi,

Try like:

=SUMIF(Sheet1!A:A,Name,INDEX(Sheet1!B:C,,MATCH(Date,Sheet1!B$1:C$1,0)))

Changes ranges to suit your actual data set.

Matty