Excel lookup and calculation
 

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.

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(A 1,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,))



--

Regards,

Peo Sjoblom




"Spaz South Africa" <Spaz South wrote in
message ...
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.