Skip to content

Instantly share code, notes, and snippets.

@Azooz2014

Azooz2014/Excel formula to sum only unique values

Created February 14, 2023 09:38
Show Gist options
  • Save Azooz2014/e98da5496f2e264df0f95ab22844bd6d to your computer and use it in GitHub Desktop.
Save Azooz2014/e98da5496f2e264df0f95ab22844bd6d to your computer and use it in GitHub Desktop.
Download ZIP
Excel formula to sum only unique values
Raw
Excel formula to sum only unique values
=IF(1/COUNTIF(`$range$:$range`,`criteria`)=1,SUMIF(`range to sum`,`criteria`,`sum`),0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment