Thread
:
Issue With SUMIF and Range
View Single Post
11-11-2022, 03:42 AM
Debaser
Windows 10
Office 2016
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
You can use:
=SUMPRODUCT(($A$2:$A$20=D22)*$D$2:$F$20)
in D23 and copy across.
Debaser
View Public Profile
Find all posts by Debaser