Problem figureing out how to dump data and set cells to 0

**naturaldissolve** · 09-05-2016, 01:36 AM

I could maybe figure this out on my own, but it will take you guys a few seconds.

I have a bunch of cells(every other cell in a row) I want to add up and then dump the data every week into a specific cell. Something like:

If(new week) ( (sum of each row(every other cell)add to total) reset these cells to 0)

I could even manuallly type in a 0 or 1 to dump the data instead of having to get the day of the week. That might be better considering I may not open it every week. I don't want to have a function in every cell. Please let me know if this is clear.

**TheN** · 09-05-2016, 01:55 AM

create a helper column aside of your data set using this formula entered in row 2 of whatever your last column is:

=mod(row(A2),2)

This will give you alternating 1/0 all the way down (double click the bottom right corner of cell after you apply this formula). After this is done, press Ctrl+Shift+L to apply a filter to you data, go to the helper column and un-select whichever number corresponds to the data you are not interested in. Highlight all the data you are interested in, and a total will be in the bottom right of your excel. type it in whereever. Put a 0 in your first cell, and double click it down to reset.

Now, if you want this automated, you have to use VBA and macros, but it shouldn't take you too long to do manually with this method.

**naturaldissolve** · 09-05-2016, 02:23 AM

I was concerned I might need a macro. Is there really no way to set a certain cell to 0 with an if statement?

Something Like:

if(these cells are full) (Set (C1, C4, C6) to 0)

Of course, you would somehow have get the data before it disappears.