thks mr Bob for immediate response!

it works superbly!

via135




Bob Phillips Wrote:
Try this

=SUM(OFFSET(B2,MATCH(A10,$A$2:$A$7,0)-1,0,1,6))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"via135" wrote
in
message ...

i am having months jan, feb.... to jun in b1:g1 & some fruit names
in
a2:a7 (say.."orange", "banana", "grapes", "apple", "mango" &
"lemon").

b2:g7 contains the monthwise sales figure for each fruit.

now what i want is, without using the pivot table, in any other
cell,
say in A10 by simply entering any fruit name (which is in col A) can
i
get the sum of total sales..for any given period. for ex. by
entering
"lemon" in A10 i should get the total sales figure of lemon (ie.
total
of B7 to G7) or total sales figure of lemon for the months jan,feb &
mar (ie. total of B7 to D7) in cell A11

pl help

thks!

via135


--
via135

------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=496051



--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=496051