Jul 28, 2020 ... I want to create a pie chart. I am having trouble however of finding the right way to count the duplicates, but only one time.

Oct 11, 2020 ... ... calculate the new aggregated value for the 52 Wk Change (that's just ... I think what I want to do may need to be done with VBA in Excel.

May 4, 2021 ... ... numbers are formatted as numbers or even accounting but it's still not right. I have checked the same formula in Excel and get the correct ...

Mar 4, 2019 ... In the actual data, there may be a lot of duplicates in column A, and I don't want to count the Data associated with any duplicates. Details.

Mar 5, 2025 ... Then I subtract those two, the values are correct: cell J5: (=SUM(J4-J3)). but breaking the same formula down in a cell doesn't work. Here is ...

Sep 30, 2019 ... You cannot sum text numbers. You need to select that range or column and format it as numbers or as Automatic. See the example ...

Nov 21, 2022 ... I would like to keep it as an array formula due to adding and changing data often. Any help or suggestions would be greatly appreciated. The ...

Nov 22, 2019 ... Remove the entries in F:H, then placed the formula in cell F1 in your screenshot. If you would like to see a demonstration of functions or ...

May 7, 2020 ... We used a FILTER() and UNIQUE() to get the data to a usable form for a QUERY() to sum your data. The formula is in K2 of your sheet. = ...

Dec 18, 2019 ... But when I copy to a new sheet, the same cell's sum value shows ... When you paste it into a new spreadsheet it assumes the values to be numeric ...

Oct 27, 2020 ... These data are based on the IMPORTRANGE formula. 2. I want to sum values (Column F and Column H) of the same date (Column B) whose results are ...

Feb 13, 2023 ... Basically, I have a list similar to this where I have to do two things with a single formula: 1. I want a sum of unique combinations between ...

Aug 27, 2022 ... In the above sheet I want to calculate duplicate value percentage with one single formula ... sum(C) where A is not null group by A",1),"select ...

Nov 20, 2020 ... I want the Output cell for each row to calculate the sum of the two (887.06), and then do the same for each cell down the Output column.

Sep 3, 2021 ... So ideally there would be multiple unique values that i want to sum and the Total order revenue of those might be of same values. I have tried ...

Apr 23, 2019 ... Excel does it by updating the SUM formula by specifying the spreadsheet ... same question I rather tediously accomplished it by doing SUM(Sheet1!

Oct 29, 2020 ... Hi All, I can't for the life of me get a sum function to add up numbers in the same cell across multiple sheets working. ... Excel and the same ...

Jan 28, 2020 ... But when I do the same numbers in excel, calculator or google sheet (without sum()), I am getting 7.056*218.080=1538.772 Please find the ...

Oct 12, 2022 ... The formula is =SUM(H3:H104) and is in H105. The sum didn't ... numbers that got it to the 924 number, it stayed the same). When I ...

Jul 6, 2022 ... ...then dragged it down to B15 and then across to H15 to fill in the range B9:H15 with the formula. Did the same for the range B19:H25. Then ...