Excel Tips No 23 : The Art of Sum Function

This free microsoft excel tips no 2 is telling to The Art of Sum Function. May be you often use sum function, In this tips I will share how to sum with a certain condition.

In this case we use SUMIF function

General form of SUMIF function is :
=SUMIF(Range that will be put a criteria,Criteria,range that will be summed)

For example, see the example below



1.Sum Cost where month is equal to January
=SUMIF(B4:B15,"January",D4:D15)

2.Sum Cost if Month not equal to January
=SUMIF(B4:B15,"<>January",D4:D15)

3. Sum Cost if Month equal to January or Month equal to February. You can use "+" to represent "OR" Function
=SUMIF(B4:B15,"january",D4:D15)+SUMIF(B4:B15,"February",D4:D15)

4. Sum all Cost that only more than 100
=SUMIF(D4:D15,">100",D4:D15)

May this tips can be usefull for you.