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.