Excel lookup and calculation

[Spaz South Africa]

Hi
I want to look in a specific row a date that corresponds with a date that I
enter and then must calculate the total sum in that column. Please help
urgent.

 

[Peo Sjoblom]

A couple of ways, assume your table is called MyTable

=SUM(INDEX(MyTable,2,MATCH(A1,INDEX(MyTable,1,),0)):INDEX(MyTable,COUNT(INDE
X(MyTable,,MATCH(A1,INDEX(MyTable,1,),0))),MATCH(A1,INDEX(MyTable,1,),0)))

or


=SUM(OFFSET(MyTable,1,MATCH(A1,INDEX(MyTable,1,),0)-1,COUNT(INDEX(MyTable,,M
ATCH(A1,INDEX(MyTable,1,),0)))-1,))