It looks a bit strange for me that you generate your month demand values into multiple columns but want to summarize only the first such column as a total. Still there are multiple approaches if you really want to do this. For example you can have a hidden column which will just contain your first month demand value and summarize this column. Or you can try to use plain excel SUMIF formula to calculate the values in required rows. Or you can use POI to set a correct formula into the total cell after the data are generated (you will have to built proper formula string in java).
-- Leo On Wed, Apr 17, 2013 at 9:45 AM, Anders <innocentl...@gmail.com> wrote: > Hi, > > I have a setting in template excel file as below: > [image: Inline image 1] > > The result sample will look like: > [image: Inline image 1] > Demand TOT is "=SUM(C5:W5:C9:W9)", it sums all values. > But I just want to "=SUM(C5:C9)". > Could you please kindly tell me how can I do this requirement? > Any advice will be appreciated!!! > > -- > －－－－－－－－－－－－－－－－－－ > ~Mia は 最高！~ > －－－－－－－－－－－－－－－－－－ > > > ------------------------------------------------------------------------------ > Precog is a next-generation analytics platform capable of advanced > analytics on semi-structured data. The platform includes APIs for building > apps and a phenomenal toolset for data science. Developers can use > our toolset for easy data analysis & visualization. Get a free account! > http://www2.precog.com/precogplatform/slashdotnewsletter > _______________________________________________ > jXLS-user mailing list > jXLS-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jxls-user > >
<<image.png>>
<<image.png>>
------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
