Posts

Showing posts with the label sum formula

SUM Formula in Microsoft excel

Image
   SUM Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used SUM FORMULA   What Does It Do ? This function creates a total from a list of numbers. It can be used either horizontally or vertically. The numbers can be in single cells, ranges are from other functions. Syntax = =SUM(Range1,Range2,Range3... through to Range30). Formatting No special formatting is needed.   Note Many people use the =SUM() function incorrectly. This example shows how the SUM has been combined with plus + symbols. The formula is actually doing more work than needed. It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).