Hi,
This looks like a CSE answer to me. Something like:
=SUM(SMALL(IF($A$2:$A$14=E2,$D$2:$D$14,""),{1,2,3,4,5})) (confirm with CSE)
See attached.
Hi,
This looks like a CSE answer to me. Something like:
=SUM(SMALL(IF($A$2:$A$14=E2,$D$2:$D$14,""),{1,2,3,4,5})) (confirm with CSE)
See attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks