Friday, 6 September 2013

Remove Junk values & Sum based on the condition in Excel


Remove Junk values in Excel:
Often while working in Excel, You will get Junk values, the simplest way to remove the Junk values is by applying the Formula Clean.
=CLEAN(Text)

Sum the values based on the condition:
For Example, Assume we have List of materials and the number of counts, but we have total counts on the specific material, we can use the SUMIF formula.
=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)



No comments:

Post a Comment

Creative Commons Licence
BLOG by Suresh is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at http://ineedapple84.blogspot.in/.
Permissions beyond the scope of this license may be available at http://ineedapple84.blogspot.in/.