SUMIF accross Multiple Sheets

Hi,

I am a moderate user of Microsoft Excel. Currently I use MS Excel 2010.

I will explain my problem briefly and post the function I use to get the result but I still need some development.

Curently I am trying to SUMIF or sum values according to some criterion accross several Sheets. Each sheet contains values in same columns.

For example, if I have values in Sheet1 in J:J column, the values in another sheet "Sheet2" are also stored in J:J column and so on.

Now I use formula: =SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!$C:$C"); $B7; INDIRECT("'"&SheetList&"'!j:j")))

I think it is a good solution, but what I am going to try is to drag the formula to the right or left, does not matter, but the J:J column does not change to K:K column or even further.

The problem may exist in using Brackets, but I could not identify other method or developed method of this function.

Please help on this, thanks in advance.

IF needed I will attach the sample file.


Regards,

Giorgi Bregvadze

THANK YOU SO MUCH.

The formula works great, thanks again, exact solution....