Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Summarising data from multiple rows
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-04-2017, 09:04 AM
xor xor is offline Summarising data from multiple rows Windows 10 Summarising data from multiple rows Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You can use a calculation intensive SUMPRODUCT formula as shown in AR2 (which may slow down Excel) or (better, if you can accept a helper column) formulas like shown in columns AU and AW.
Attached Files
File Type: xlsx 123_A.xlsx (298.3 KB, 10 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting data in scattered rows into rows following each other MorneDJ Excel 3 12-10-2016 12:35 AM
Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each Record Emailed? Sgt Rock Mail Merge 6 08-10-2016 11:03 AM
Extracting multiple words from one cell into individual rows while copying all other data randyaserve Excel Programming 4 10-05-2015 09:52 AM
Inserting multiple rows of data from Access into Word booseyboo Mail Merge 1 05-23-2014 03:09 AM
Moving data from multiple rows to 1 row for each program number ballj_35 Excel 3 08-01-2012 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft