Some sort of conditional sum?
 

I have a table of data set up as follows:

Customer 31/10/08 30/11/08 31/12/08
abc 20 35 50
def 45 30 24

In a separate sheet I have a summary sheet whichwill show totals as follows:

31/10/2008
Total Port 65

I want the Total port to change according to the date in the cell above i.e.
the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08.

I don't think this is complicated but at this time of the day its doing my
head in so any help would be appreciated.

Many thanks,

Andrew

Some sort of conditional sum?
 

Try this:

A10 = date to match

=SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) ))

--
Biff
Microsoft Excel MVP


"Andrew Mackenzie" wrote in message
...
I have a table of data set up as follows:

Customer 31/10/08 30/11/08 31/12/08
abc 20 35 50
def 45 30 24

In a separate sheet I have a summary sheet whichwill show totals as
follows:

31/10/2008
Total Port 65

I want the Total port to change according to the date in the cell above
i.e.
the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08.

I don't think this is complicated but at this time of the day its doing my
head in so any help would be appreciated.

Many thanks,

Andrew

Some sort of conditional sum?
 

Thanks Biff, Worked a treat!!

Andrew
"T. Valko" wrote in message
...
Try this:

A10 = date to match

=SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) ))

--
Biff
Microsoft Excel MVP


"Andrew Mackenzie" wrote in message
...
I have a table of data set up as follows:

Customer 31/10/08 30/11/08 31/12/08
abc 20 35 50
def 45 30 24

In a separate sheet I have a summary sheet whichwill show totals as
follows:

31/10/2008
Total Port 65

I want the Total port to change according to the date in the cell above
i.e.
the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08.

I don't think this is complicated but at this time of the day its doing
my
head in so any help would be appreciated.

Many thanks,

Andrew

Some sort of conditional sum?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Andrew Mackenzie" wrote in message
...
Thanks Biff, Worked a treat!!

Andrew
"T. Valko" wrote in message
...
Try this:

A10 = date to match

=SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) ))

--
Biff
Microsoft Excel MVP


"Andrew Mackenzie" wrote in message
...
I have a table of data set up as follows:

Customer 31/10/08 30/11/08 31/12/08
abc 20 35 50
def 45 30 24

In a separate sheet I have a summary sheet whichwill show totals as
follows:

31/10/2008
Total Port 65

I want the Total port to change according to the date in the cell above
i.e.
the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08.

I don't think this is complicated but at this time of the day its doing
my
head in so any help would be appreciated.

Many thanks,

Andrew