rprasanthkumar
New Member
Dear I am using Excel 2010 and tried out the SUMIFS. It was all perfect as it produced the results what I wanted.
But the story is now a bit anticlimax. The moment I close the base file from which the sumifs formulae picks up the data, all the cells in the output file shows as "Values".
This error was not coming when we use sumif function. Why is this happening? Is there any way we can fix this error from appearing?
But the story is now a bit anticlimax. The moment I close the base file from which the sumifs formulae picks up the data, all the cells in the output file shows as "Values".
This error was not coming when we use sumif function. Why is this happening? Is there any way we can fix this error from appearing?