The attached excel worksheet can explain better of what I need. I need to calculate the attached based on fiscal year starting with August and ending in July for the next 5 years. If you have any other questions for better understanding please let me know.
I'm not sure if the attachment ability of these discussions work but I notice there is no attachment with my question. So I'm going to post what I put in the attachment and I pray that someone understands:
Our fiscal year is from months August to July. So if I put an 8 in F22 it will calculate the first year column AC for F22 to Q22. If I enter 10 in F22 then months 10 through 19 would calculate year 1 because year one would be 8 through 19 and months 20 to 31 would be based on year 2, etc... This code is located in F39 to Q39: =SUMPRODUCT(F23:F38*OFFSET($AC$5,0,INT(F22/12)):OFFSET($AC$20,0,INT(F22/12))) which works perfectly for the 12 months, 1-12. So I need for it to calculate by fiscal year for the next five years per the table above, i.e., Aug 2012 to July 2013, year 1; Aug 2013 to July 2014, year 2; Aug 2014 to July 2015, year 3; August 2015 to July 2016, year 4; and August 2016 to July 2017, year 5.
Divine, I think we are confused with the exact sums involved. I'm quite good at excel macros, even I'm stumped. ;) Try and attach your worksheet and I will play with it. The only way I'll be able to help you get a solution.... I need to see what the sheets are doing and why to grasp your problem... :)
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...