Thread
:
Summing every third cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Summing every third cell
see worksheet.functions for subj
sum every other row in column
--
Don Guillett
SalesAid Software
"Jason Hancock" wrote in message
...
Well, I've tried several different things, but have not been successful.
I'm trying to sum every third row of a particular column (i.e.
A2+A5+...) What I have written so far is:
For n = 2 To 233 Step 3
For m = 4 To 15 Step 1
Cells(236, m).FormulaR1C1 = ??????
Cells(236, m).NumberFormat = "$#,##0_);[Red]($#,##0)"
Next
Next
Any help would be great. Thanks!
Jason
*** Sent via Devdex
http://www.devdex.com
***
Don't just participate in USENET...get rewarded for it!
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]