•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Problem with aggregate and sum
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]
Want to read more?
Check out the full article on the original site
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