Formula for a running total in one cell

Trevor G · #1 09-06-2017, 06:24 AM

When you state a running total the formula you are using is only pointing to a single cell on a single sheet, what type of combination are you after?

cdon1983 · #2 09-06-2017, 06:31 AM

The idea is for the user to enter the answers on the home tab using the drop down menus with either yes or no. These answers will then show as a number on the Group tab. This is far as I got... I was hoping to set up a button with a macro that would save the answers after the survey was complete and then wipe the answers ready for the next survey. The answers that a found on the Group tab would then be accumulated as more and more survey are completed. I hope that makes sense..

Trevor G · #3 09-06-2017, 07:05 AM

What I can suggest is to Add an extra row above the drop downs and use an IF Statement to =IF(B4="YES",1,0) you can always hide the column, then you simulate copying the cell then select the home sheet and simulate using Paste Special and Values and Paste Special and Add. Which will then add the value to the total. Finally look to clear the YES from the cell.

Sampel code is below:

PHP Code:


			
Sub AddToTotals()
'This is a demo only for one cell if this works for you
'Then it needs to be worked on for all the other cells.
    Sheets("Homes").Range("b3").Copy
    Sheets("Group").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks _
        :=False, Transpose:=False
 Sheets("Homes").Range("b4").ClearContents
 
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Simple Spread Sheet	TThomas	Excel	1	04-07-2016 09:01 PM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
changing the spread sheet location on embeded pie chart	otuatail	PowerPoint	1	03-04-2014 07:20 AM
Condensing a spread sheet	hawkeyefxr	Excel	4	08-22-2012 05:17 AM