View Single Post
 
Old 11-11-2022, 03:42 AM
Debaser's Avatar
Debaser Debaser is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

You can use:

=SUMPRODUCT(($A$2:$A$20=D22)*$D$2:$F$20)

in D23 and copy across.
Reply With Quote