It turns out that I have a file in which I fill a form and I fill in the tables of an Excel document by day (The day is indicated in a field of the Excel form). These tables generate data graphs. Now, I want to group what I generate in my tables for days in months. When adding the data of those days in the month (and making the relevant verification that it is evidently that month) the sum gives me 0. I have verified that it is not by the format of any cell and to top it if I strike Fx in the bar functions, it predicts the number I expect as a result.
I have also been testing if he always shows me a 0 when I add, or in what cases he shows me. So far, it seems that I am shown a 0 every time I add cells that have a value that comes from a formula, that is, if I add 2 values put together I add them correctly, but if I add a value that comes from a formula with Values set by hand also returns a 0.
I enclose the screenshot of one of the tables together with the formula of its sum of totals on the right so that the problem is better understood.
Point:
I kept on snooping with the problem and I just realized another one, which is probably related to the first one.
It turns out that I have a field in my form that indicates the day we are on. The data of the tables are updated according to the selected day. The formula of for example cell C4 located in the table is:
= YES (Form! B6 = Table1! C3; Form! $ B2; C4)
The yes condition only compares the days to know if it should be inserted in that cell. If it is, enter the data, and if not, leave cell C4 as it was (to preserve the data of the previous days). Now when I update the formula, the value becomes 0 and I lose the data.
Also, I can confirm that all of this that is giving problems has been working before.