•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Problem with aggregate and sum
Our take
Hi everyone! I'm seeking assistance with a challenge I’ve encountered while working on an Excel spreadsheet. After a long break from using Excel, I'm trying to calculate the total sum of values in a column that includes dollar signs ($). Despite my attempts to use the AGGREGATE function, it still returns zero, and the SUM function gives a value error. If I remove the dollar signs, the calculations work correctly. Could anyone provide insights on what I might be doing wrong? Thank you!
Hi everyone, i'm looking for some help since searching the web as not worked for me.
I started doing an Excel sheet after a long time, and i'm trying so get the Total Sum of the values in a colum, while those values have $ on them.
Now i've seen that Aggregate would make it so that it would ignore the $, but it's not working, it still returns a 0. (If i remove the $ he does it correctly). Sum just returns Value
Can you tell me what i am doing wrong please? Thank you!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Small Business rounding issueHi, Can anyone identify why my spreadsheet is calculating the total to be $6133.33 instead of $6133.20? 153.33 total hours x $40/hr. I've been using the same spreadsheet for a year, the formulas are correct, this hasn't happened before, I can't figure out how to fix it. This is on sheets. Thank you https://preview.redd.it/0tzyhv5xkkxg1.png?width=708&format=png&auto=webp&s=7376ba5124c04fef83cea620b23810079a01655f https://preview.redd.it/lp1vzu5xkkxg1.png?width=702&format=png&auto=webp&s=68ca02b9d005fff97f4f69615e542d85fb02c9d1 https://preview.redd.it/5g9zi96blkxg1.png?width=1042&format=png&auto=webp&s=956143ad31c7e99cbd5551ba3f9ac9e1dff00639 submitted by /u/alicat9 [link] [comments]
- Blank cells are being summed as a value greater than five using a SUM(IF functionHi! I have a large dataset of 7-day schedules that I am summing to calculate breaks. The function is setup like this: =SUM(IF(CELL1>5, 0.5, 0)), (IF(CELL2>5, 0.5, 0)) and so on until all seven days are tabulated. Because a full time person would only work 5 days a week, at least 2 days are blank per row, but we're open all 7 days and I want to sum the entire spreadsheet, so I have to count all 7 days. A full time person should have 2.5 hours per week. For some reason the function is mostly working, but about a third of the results are larger than they should be because it's counting some blank cells as greater than 5. For example, a part time person working only 3 days should have 1.5 break hours, but the function returns 3.5 because it is counting all the blank cells as containing a value > 5. What's really strange is it is only doing this some of the time. Every row has at least two blank cells, but only about a third of the sums are wrong. I can't figure out why. The columns are all formatted as a number. The value does update correctly if I manually enter a "0" in the blank cells, but this is a very large dataset and that would take forever. Thoughts? submitted by /u/andylefunk [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#real-time data collaboration#real-time collaboration#financial modeling with spreadsheets