AnsweredAssumed Answered

PiAdvCalcDat() Need to sum this array in excel without VBA and without printing array

Question asked by rebelfan43 on Jul 10, 2017
Latest reply on Jul 12, 2017 by JánosPetró


I am using a flow totalizer tag, and I want to sum the maximum daily value across the month.


=PIAdvCalcDat('1010 Monthly Data 2'!$B$2,"3/1/2017 12:12:00 am","4/1/2017 12:12:00 am","1d","maximum","time-weighted",0,1,0,"Database")


This is the current cell formula that I am using. This returns an answer that says "resize to show all values".  If I resize it, it returns an array with all the values that I want to be summed printed onto the screen.  However, I want to sum these values and pull this array all in one cell because I need the sheet to be simple and easy to read and present.  I also do not need to use a macro/VBA.  The totalizer pulls the maximum value for each day.