Summarising data from multiple rows

		Microsoft Office Forums > Microsoft Excel > Excel
Summarising data from multiple rows

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-04-2017, 09:04 AM

xor

Windows 10 Summarising data from multiple rows

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

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

123_A.xlsx (298.3 KB, 10 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 03:54 AM.