Thread
:
Summarising data from multiple rows
View Single Post
01-04-2017, 09:04 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
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, 8 views)
xor
View Public Profile
Find all posts by xor