Register
Help
Remember Me?
Forum
New Posts
FAQ
Calendar
Forum Actions
Mark Forums Read
Quick Links
Today's Posts
View Site Leaders
What's New?
Advertiser Disclosure
Advanced Search
VBForums
Visual Basic
Office Development
Sum every other row ?
If this is your first visit, be sure to check out the
FAQ
by clicking the link above. You may have to
register
before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Results 1 to 2 of 2
Thread:
Sum every other row ?
Thread Tools
Show Printable Version
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
Previous Post
Next Post
Oct 16th, 2006,
10:18 AM
#2
TheBionicOrange
View Profile
View Forum Posts
Thread Starter
Frenzied Member
Join Date
Apr 2001
Location
Cardiff, UK
Posts
1,818
Re: Sum every other row ?
never mind ... got it
I used :
=SUMPRODUCT((MOD(ROW(A1:A1000)-ROW(A1),2)=0)*(A1:A1000))
Reply With Quote
Quick Navigation
Office Development
Top
Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Visual Basic
Visual Basic .NET
CodeBank - VB.net
Visual Basic 6 and Earlier
CodeBank - Visual Basic 6 and earlier
TwinBASIC
CodeBank - TwinBASIC
Universal Windows Platform and Modern Windows Experience
Xamarin
Mobile Development
ASP, VB Script
Office Development
Database Development
Reporting
API
Games and Graphics Programming
Game Demos
COM and ActiveX
Network Programming
Visual Basic FAQs
.NET and More
ASP.NET And ASP.NET Core
Visual Basic .NET
MVC .Net
C#
Microsoft Azure and Cloud Dev
WPF, WCF, WF
.NET Architecture and Design
Silverlight
General
General Developer Forum
IoT, IoE, and Maker Forum
Testers and Testing
Application Testing
Application Deployment
Linux Development
General PC
VBForums Coding Contests
Contest Entries
Code It Better
Maths Forum
Other Languages
Other BASIC
C and C++
Java
PHP
XML, HTML, Javascript, Web and CSS
jQuery
Assembly
Other Programming Languages
VBForums CodeBank
CodeBank - Visual Basic .NET
CodeBank - Visual Basic 6 and earlier
CodeBank - ASP / ASP.NET / Blazor / MVC / Web API
CodeBank - C#
CodeBank - C++
CodeBank - Java / J#
CodeBank - PHP
Codebank - Game Programming
CodeBank - JavaScript
Codebank - Cascading Style Sheets (CSS)
CodeBank - Other
VBForums UtilityBank
UtilityBank - Utilities
UtilityBank - IDE Add-Ins
UtilityBank - Components
UtilityBank - Tutorials
UtilityBank - Other
Projects
Project Requests
Project Communication Area
Jobs
Just VB Jobs
Open Positions (Jobs)
Looking for Work
Community
Forum Feedback
General Discussion / Chit Chat
World Events
Forum Test Area
«
Previous Thread
|
Next Thread
»
VBForums
Visual Basic
Office Development
Sum every other row ?
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
[VIDEO]
code is
On
HTML code is
Off
Forum Rules
Click Here to Expand Forum to Full Width
Reply With Quote