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
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