How does this solution of the subset sum problem‍​​ work?

Excel problem

• QUESTION: I have a range A1:A600 and I want to sum values of column A in(Column B)in a set of four. for e.g: B1: sum(a1:a4) B2: sum(a5:a8) B3: sum(a9:a12) for now I am entering this formula in every cell and it is hectic is there any solution because simple dragging doesn't work. Earnestly waiting for your solution. Thanking you Talha ANSWER: In B1, enter =SUM(OFFSET($A$1,4*(ROW()-1),0,4,1)) and copy down the column. ---------- FOLLOW-UP ---------- QUESTION: sir in reference to your above reply I would like to thank you as it has solved my problem almost, but I still have a query that the formula given above works only if it is applied in the first cell and then it is dragged if applied from the second cell or any other cell it gives wrong answer. Plz reply... How to convert BHATTEXT() into Indian Rupee Text. for eg: Rs.10,100/-(Rupees ten thousand one hundred only) I hope you can help. When I open anspreadsheet, I am first prompted to enter my MS product key. I enter the key and the response I get is 'incorrect key'. Then I proceed to the sheet and it's locked .... I can't enter info in the cells. This problem is recent. This problem only started about 2 weeks ago. Prior to that, I had no problems. QUESTION: I want to count the amount of children that are eight or over eight AND are Boys. The ages are in colomn M6:68 and Genders are in N6:N68 and in the form of "G" or "B". Ben Anderson ANSWER: You didn't specify version of- if it's2007 then the sumifS function will do it - or in any version try =sumproduct(--(m6:m68>=8),--(N6:N68="B")) the double minus signs are important here! ---------- FOLLOW-UP ---------- QUESTION: Sorry it was2003 that formula worked but when i tryed to change it for the girls side the answer was wrong do i need to make any other changes Ben QUESTION: Respected I was working with anSpreadsheet in my office. Suddenly my computer shut down due to power failure. All my data was already saved but later, upon opening the file a message appeared that "file.xls cannot be accessed. The file may be read only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding." I am working in MS Office 2002. This was a very important file which was created with a lot of effort. Please tell me how can I open the file and recover my data? Yasir Mahmood. ANSWER: Lot more details are required. First where is the file is located? I understand that it should be Located in server. If the file is located in server, the server might have been busy or the technology person might have changed the disk protection method to write protected. Otherwise go to the location of the file and select the cursor by placing the mouse pointer on that file and do right click>>Properties>>General>>Attributes>>Check whether the Read Only Check box is having a tick mark. If it is having the tick mark then uncheck the tick mark and give Apply and Ok now you can use the file. If it is not having the tick mark then open the file which will say it will be opened in read only mode open it as read only file and press F12 which will ask you to save the file. Now save it in your Personal PC. Nothing will happen in opening the file as read only and saving it in someother location. ---------- FOLLOW-UP ---------- QUESTION: File is located in my PC, not on the server or else where. And it is not read-only. Respected I was working with anSpreadsheet in my office. Suddenly my computer shut down due to power failure. All my data was already saved but later, upon opening the file a message appeared that "file.xls cannot be accessed. The file may be read only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding." I am working in MS Office 2002. This was a very important file which was created with a lot of effort. Please tell me how can I open the file and recover my data? Yasir Mahmood. Respected I was working with anSpreadsheet in my office. Suddenly my computer shut down due to power failure. All my data was already saved but later, upon opening the file a message appeared that "file.xls cannot be accessed. The file may be read only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding." I am working in MS Office 2002. This was a very important file which was created with a lot of effort. Please tell me how can I open the file and recover my data? Yasir Mahmood.

• Answer:

  On a blank worksheet, fill A1:A4 with 1s, A5:A8 with 2s, A9:A12 with 3s. In B1, enter =SUM(OFFSET($A$1,4*(ROW()-1),0,4,1)) Copy from B1 down through B3. B1 will display 4, the sum of the 1s in A1:A4. B2 will display 8, the sum of A5:A8. B3 will display 12, the sum of A9:A12. As best I understood it, this is exactly what you asked for. If you want something different, please ask using a clear, concrete example, as I've done above. Don't write things like "applied from the second cell." Use preciselanguage to tell me exactly what values or formulas you're talking about, in exactly which cells. bhasker, Here is a link to Shah Shailesh's site who provides a free addin that provides support for what you want: http://shahshaileshs.web.officelive.com/Addins.aspxSeveral free addins - one does rupees to words - from Shah Shailesh scroll down as it is more toward the bottom (or use the little hyperlink menu at the top) and another site. http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html these both specifically do the Indian Rupee The problem you describe usually occurs when you are using a trial version which allows for X amount of uses or X days from install/activation date. If that is the case than the software will need to be purchased before you can proceed with use. If it is not the case, the links below will give you access to Microsoft help desk professionals: Microsoft help area for additional information http://office.microsoft.com/en-us/help/default.aspx Microsoft Help Blog: http://blogs.msdn.com/microsoft-help/ Microsoft Assisted Support: http://support.microsoft.com/select/default.aspx?target=assistance&c1=505& Hope this helps to resolve your issue. well, the formula should return the right result but do all the girls entries actually have G - or do some have (perhaps) G space - which would cause the problem. However,as they are either girls or boys, surely the girls is =sumif(m6:m68,">=8")-BoysResultCell If it helps, my email is [email protected] Sometimes theExe will keep on running... Try the below:- Close all your files and all the applications. Now press cntrl+shift+esc and in Process Check whether theexe is running if it is running select it and give End Process. After that Just Restart the system. Now open the file after restarting the system. It will definitely work!!! I'd first try to use explorer to find the file and check that it looks ok from there - then try to open it directly from explorer. Otherwise, worth trying the drop down button at the right of the OPEN button on the file open dialog box which will give you the option to repair a file. You can get me directly by email if you want to mail me the file if you are still having problems - [email protected] will get to me. Try this (Success not guaranteed) - -- Start Excel -- Open (This should open navigation box) -- Browse to the file you want to open (Do not double click) -- At the bottom of navigation box there is a button for "OPEN" with an arrow on side. Click on arrow and choose - "Open and repair". -- If you are satisfied with contents displayed, save as - Different name.