I need to sum every 10th cell in row 6 for the range E6 to DS6. I found several postings on how to sum every nth cell in a column, but nothing about every nth cell across a row. So far, all my attempts to modify the formulas to sum every nth cell in column do not produce the correct answer across a row. I am using the sumproduct and mod formulas…is this not correct to sum every 10th cell across a row? THANKS.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Sum every 10th cell in a row (Office XP)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Sum every 10th cell in a row (Office XP)
- This topic has 4 replies, 2 voices, and was last updated 16 years, 5 months ago.
AuthorTopicJimmyc5559
AskWoody PlusDecember 16, 2008 at 3:18 am #456060Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
Jimmyc5559
AskWoody PlusDecember 16, 2008 at 3:35 am #1137961Hans,
It works..no surprise. Can you explain the =5? This is where my error was and I have re-read the help..but I still don’t get how you selected 5 for this value. THANKS.EDIT: Is the 5 derived because column E is really column 5 and this should be my remainder when performing the mod function????
-
WSHansV
AskWoody Lounger -
Jimmyc5559
AskWoody PlusDecember 16, 2008 at 3:42 am #1137966Wonderful…..thank you. I actually need 10 formulas like the one you provided and now I know the “secret”…thanks for sharing!!
I had spent more than hour trying to make it work using the help file…before my post. Too bad I didn’t need to sum every nth cell in a column…I found that answer easily and I guess I thought it would be just as easy to convert this formula to a sum every nth cell in a row formula. I never really thought about the columns being “numbered” before.
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Woody
by
Scott
3 hours, 48 minutes ago -
24H2 has suppressed my favoured spider
by
Davidhs
3 hours, 49 minutes ago -
GeForce RTX 5060 in certain motherboards could experience blank screens
by
Alex5723
18 hours ago -
MS Office 365 Home on MAC
by
MickIver
11 hours, 49 minutes ago -
Google’s Veo3 video generator. Before you ask: yes, everything is AI here
by
Alex5723
1 day, 8 hours ago -
Flash Drive Eject Error for Still In Use
by
J9438
1 day, 9 hours ago -
Windows 11 Insider Preview build 27863 released to Canary
by
joep517
2 days, 2 hours ago -
Windows 11 Insider Preview build 26120.4161 (24H2) released to BETA
by
joep517
2 days, 2 hours ago -
AI model turns to blackmail when engineers try to take it offline
by
Cybertooth
1 day, 6 hours ago -
Migrate off MS365 to Apple Products
by
dmt_3904
1 day, 7 hours ago -
Login screen icon
by
CWBillow
21 hours, 45 minutes ago -
AI coming to everything
by
Susan Bradley
7 hours, 6 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
2 days, 18 hours ago -
No Screen TurnOff???
by
CWBillow
2 days, 18 hours ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
2 days, 19 hours ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
3 days, 7 hours ago -
How well does your browser block trackers?
by
n0ads
2 days, 17 hours ago -
You can’t handle me
by
Susan Bradley
16 hours, 10 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
2 days, 10 hours ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
3 days, 18 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
2 days, 21 hours ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
3 days, 18 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
3 days, 18 hours ago -
Lumma malware takedown
by
EyesOnWindows
3 days, 7 hours ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
4 days, 3 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
4 days, 3 hours ago -
Meet Gemini in Chrome
by
Alex5723
4 days, 7 hours ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
4 days, 7 hours ago -
Trump signs Take It Down Act
by
Alex5723
4 days, 15 hours ago -
Do you have a maintenance window?
by
Susan Bradley
2 days, 20 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.