Sum column whilst avoiding duplicates

[hyd1956]

Hi

Can you help with with a formula to sum entries within a column based on multiple criteria and avoiding counting duplicates.

Column E has the numbers I would like to sum when column V = "Y", Column A = "Y" and it is not a repeat entry based on the name held in Column B.

As a note, Columns A to U are part of a power query table.

Thank you

 

[Special-K99]

Let's clarify this.

You want to SUM column E when column V is "Y" and column A is "Y" but only if the name in column B hasn't occurred before.
Is that correct?

 

[hyd1956]

Yes thank you

 

[Special-K99]

Here's one solution, not sure if it is suitable to your needs.
Use a Helper column, ie
in an empty column against each row that you have a value in B
let's use column D

in D1 put
=COUNTIFS(B$1:B1,B1)
and copy down the column
This will count the number of times the value in B occurs in the list.

Then for the total

=SUMPRODUCT((A1:A7="y")*(V1:V7="y")*(E1:E7)*(D1:D7=1))

 

[hyd1956]

Thank you. I don't know why I didn't consider a helper column. The sum product option didn't calculate so I've used the sumifs option to include Column D:D, 1 and it seems to have done the trick