Sumif function tip

Ever tried to sum up all the positives/negatives in a column per GL account and per month?  If the task is done manually it will certainly turn out to be boring and repetitive.  However by using the Sumif function this seemingly boring and complex task can be simplified.  Follow our example below as we show you how. The screen shot below will be used to illustrate this example.

Applies To: Excel 2003, 2007 and 2010

1. Select cell B9 and enter the following formula: =SUMIF(B3:B8,”>0″)
2.  Copy the formula across to cell E9
3. This will give you the total positives for all the months as per screen shot below
4. Select cell B10 and enter the following formula: =SUMIF(B3:B8,”<0″)
5. Copy the formula across to cell E10
6. This will give you the total negatives for all the months as per screen shot below

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations