Philip Treacy said Not sure what happened but I have reattached the file so you should be able to download it now. Hai Phil.. Thanks for attach...
Hai Mynda.. Thanks for fast feedback, but just want to inform you that I can't download attachment had you provided above.. When I click the att...
PGCodeRider said If you create a custom function, you can get it pretty easily. I built one below. If you then put this formula in cell G3, =Rank...
SunnyKow said Hi Azri See my example (with instructions included) Good luck Sunny Woowww... work great like honda engine.. Thanks sun...
SunnyKow said Hi Azri To create a formula with a 3-D reference in the argument, perform the following steps: Click the cell where you wan...
SunnyKow said Hi Azri If your worksheets all have the same structure, perhaps you can try using 3-D summing. For example =SUM(Sheet1:Sheet3!C3)...
Anders Sehlstedt said Hello Azri, As per your setup I would use an array formula to sum the different criterias from the different sheets. In you...