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.

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.

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
Permissions beyond the scope of this license may be available at