Count values in Cells Across

  • Thread starter Thread starter Shari
  • Start date Start date
S

Shari

I want to calculate the values in cell A1 across.

Eg. Cell A1 has a value of 36. I want to calculate the values across
in the 36 non blank cells located in the same worksheet.

Any help appreciated.
Thanks in advance
 
Hi, put this in a module and give it a keyboard shortcut so you ca
activate it, its just a macro recording of selecting cell A2 the
clicking on the sum symbol on the standard toolbar and then draggin
all the cells you want to calculate.

hope this helps
Simon
Sub cellcalculate()
Range("A2").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-1]C:R[-1]C[36])"
Range("A2").Select
End Su
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Countif across sheets? 5
Excel formula, sum the value cell and if empty cell left blank 0
Display entire number in cell 3
Need Macro... 8
Count values in Cells Accross 1
Sum non blank values across - Excel 1
Excel Need Countifs Formula Help 0
Set value of a cell with a dropdown list during run time (C#) 10

Back
Top