Forum Discussion

Ricardo Herrera's avatar
Ricardo Herrera
Copper Contributor
Jun 04, 2018

Error copying data from a worksheet and using it in sumifs

Hello, I have the following problem: I copied data from a bank statement to a spreadsheet, I used the sumifs function, to add the "X" column of positive values ​​that are between two dates, the result comes "o", put some data typed directly into the worksheet and the function works normally . I configured the columns as follows: Dates as abbreviated dates "00/00/0000"; Values ​​such as accounting $; I believe excel is not recognizing the data pasted from the other worksheet, why? Attached prints of the issue. Thanks in advance for your help.

No RepliesBe the first to reply