Categories: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

Producing a SUM for a dynamic number of columns

Showing 1-4 of 4 messages
Producing a SUM for a dynamic number of columns ChristopherHydak 7/15/12 2:21 PM I have a row of data for hourly availability that I want to sum up, but for each new day, it should exclude a column with the day header that is no longer valid. I've attached a screenshot to make it easier to understand what I need.  On 7/16/2012, m
Re: Producing a SUM for a dynamic number of columns Yogi Anand 7/15/12 6:08 PM Hi ChristopherHydak: Let me see if I have understood you correctly ... Please have a look at the solution I have posted in my following blog post yogi_Sum Up For Each New Day In Row 5 Numbers In Row Below http://yogi--anand-consulting.blogspot.com/2
Re: Producing a SUM for a dynamic number of columns ChristopherHydak 7/15/12 9:49 PM Yogi, That worked beautifully, thanks.   Christopher
Re: Producing a SUM for a dynamic number of columns Yogi Anand 7/16/12 5:59 PM You Are Very Welcome ChristopherHydak ... Now Let Us Keep Googling.