 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Add Every Other Row
Hi Folks - I have data that looks like this: Identity Crimes Seminar - 04/13/2005 16 27 43 13 99 16.16% 27.27% 43.43% 13.13% 100.00% Internal Affairs Course - 11/08/2004 3 15 6 1 25 12.00% 60.00% 24.00% 4.00% 100.00% I want to sum 16 and 3 in the first column. Is there a way to sum every other row in a column? I have 1000 rows of data like this. Thanks, Michael =SUMPRODUCT((MOD(ROW(G1:G20),2)=1)*(G1:G20))  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hi Folks - I have data that looks like this: > [quoted text clipped - 9 lines] > > Michael
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.