i want this to add from C13 TO C15 to have a return value $300. becoz i want
the formula to match 3 cells.

"Max" wrote:

That description wasn't really much to go by ... anyway here's a venture
hazarded via SUMPRODUCT and OFFSET which tries to align closely with/use the
same "ranges" depicted in your original index/match:
=SUMPRODUCT(--(A13:A1000=C13),OFFSET(A13:A1000,,MATCH(D2,A11:BZ1 1,0)-1))
Above caters for multiple matches for C13 within A13:A1000 (these can be
scattered matches anywhere within A13:A100), and presumes that you want to
sum up the corresponding cells in the column range specified by where D2 is
found in the range A11:BZ11 (the OFFSET bit grabs this column). Bullseye or
9.9/10? celebrate it, hit the YES below. Let me know
--
Max
Singapore
---
"Rohit" wrote:
so i want match from $C$13:$C$15 and return value as agregated. eg if it
match C13 where is $100, C14=$100 and C15=$100, therefore the return value
should be $300.

basically i want to sum the match cells (C13:C15)

hope it help