Jan 5, 2023 · 3 I have two columns one for date and one for value. the date columns have different dates with duplicates date and the values are different with duplicates values. Is there any way to …

Mar 7, 2018 · Excel - sum values based on distinct value in another column Asked 7 years, 9 months ago Modified 7 years, 9 months ago Viewed 13k times

Feb 28, 2024 · I need some help creating a formula. I have an excel file with 3 columns and I need to sum values of column C, based on the unique values of column A even if I filter something in column …

Jun 19, 2020 · Criteria Value A 10 A 10 B 20 C 40 I would like a formula that sums the Value column based only on unique strings in the Criteria column. For example, in the above sample, the output …

Oct 14, 2020 · In Cell B1 I want to sum the unique values from Column B. B1 = 700 + 300 + 200 + 400 In case a value appears two times it should only be included one time in the sum function.

Aug 28, 2016 · I need add a secondary criteria to only sum unique values when column A is the same number which would result in multiple values (361.9, 12 and 8) as shown below.

Dec 10, 2013 · 1 I'd go with a pivot table for this. Select your data (with headings) and click the Pivot Table button on the Insert ribbon. Use the "number" field for row labels box and "duration" for the …

Apr 10, 2025 · Excel Pivottable with unique values based on the value of two columns and sum the respective scores and option to filter Asked 7 months ago Modified 7 months ago Viewed 116 times

Feb 2, 2024 · On the summary tab, I need the formula to look at the data in column W and sum the values for the unique numbers in column A. I also need the formula to subtract out the values from …

Jul 9, 2002 · Can I use Sum distinct function in pivot table. or How can i Add sum distinct as a function in excel Akhilesh