**Use SUMIF Formula in Excel**

If you want calculation of specific range amount or specific person record in excel then sumif is uses for that

Learn how to use Sumif in excel sheet; Create some data as below and practice your self in excel

An excel sheet of daily sale record

Now First we Take Example of

**Less than < calculation**in excel
i want calculate all amount who is less than 50000 thousand

And it is our formula we apply

**=SUMIF(B2:B5,"<50000")**

**=SUMIF(C2:C5,"<50000")**

And Get Result see above image

Calculate Amount

**Greater Than >**in excel 50000 Thousand
now we calculate amount above 50000 thousand and use greater than sign for this

And it is our formula we apply

**=SUMIF(B2:B5,">50000")**

**=SUMIF(C2:C5,">50000")**

Try Excel SUMIF formula in yourself and see result

**Calculate Specific Product or sales person amount in excel**

if you want calculate specific sales person or product amount then you need little change in your formulas

see example how can we do it in excel

use formula as example

**=SUMIF(A2:A5,"Product one",B2:B5)**