View Full Version : [SOLVED:] Values Adding
I have a problem on my spredsheet now. Since I don't want to use "+" to add up some values, would anybody let me know how to add up values in a column after every five 3 lines?
Thank you!
Bob Phillips
05-05-2005, 01:35 PM
five 3 lines, I assume you mean every 3 lines
=SUMPRODUCT(--(MOD(ROW(A1:A100),3)=0),A1:A100)
brettdj
05-05-2005, 06:47 PM
What row does your data start in?
Values from the first one then after every three lines. Thanks!
Bob Phillips
05-06-2005, 05:46 AM
=SUMPRODUCT(--(MOD(A1:A30,3)=1),A1:A30)
just adjust A30 to the end of your range
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.