Quote Originally Posted by NBVC View Post
Well... excuse me.. I hadn't seen that you updated your original post instead of adding the attachment in a new post to follow sequence.....

... anyways, see attached.

Formula in Q9 of Sheet 1:

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:3"))&"'!A1:A10"),P9,INDIRECT("'Sheet"&ROW(INDIRECT("1:3"))&"'!B1:B10")))
This looks at A1:A10 of each sheet 1, 2 and 3 and looks for the value that is in P9 and sums corresponding numbers from B1:B10 on each sheetl

Adjust ranges to suit and change 1:3 in the formula to encapsulate all sheets (i.e. 1:30)
can you please explain the concept of this formula

like the detail of this formula and mail me at

muhammad.faraz-1@standardchartered.com


Please explain the logic what does this formula mean

like whats indirect and all



Please tell me the formula which also work in excel 2003