I am trying to sum values in a column ignoring errors. When I try to use the aggregate function, I get 0 as a result, but when I look at the result shown in the formula pop-up, it is around 147. This same behaviour repeats if I try to use SUMIF or SUM(IFERROR(ref,0)).
Captura de tela 2025-06-16 111013.png
"AGREGAR" = AGGREGATE
"[CMV Ponderado (Pre�o atual)]" is reference to the values in the table in the same column of the cell
2.png
Last edited by ViniciusLima; 06-16-2025 at 10:24 AM.
Hi,
welcome to the forum.
Please upload you sample file, so we can check what is wrong...
BR, Alexandra
Best regards, Alexandra
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved"
I've opened the workbook now and the problem is gone, maybe it was a matter of restarting excel for it to be solved. Thanks for your attention!
Last edited by ViniciusLima; 06-16-2025 at 12:19 PM. Reason: add more details
You´re welcome!
Well, now i've perceived sometimes the problem happens sometimes it doesn't and it is being annoying, so please help.
Sample files are attached.
There are two workbooks, they link to each other in some formulas. They're the same except that one has data about some of our products and the other about other ones. I've deleted some data i did't want to share.
The problem occurs in the totals of the table in "CMV PONDERADO" sheet, in the "CMV Ponderado (Preço sugerido)" and "CMV Ponderado (Preço atual)" columns.
Thanks in advance!
I don't see an AGGREGATE based formula in the totals of the table in of the "CMV PONDERADO" sheet, in the "CMV Ponderado (Preço sugerido)" and "CMV Ponderado (Preço atual)" columns for either file attached to post #5.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks