The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.

So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel function to use, as I explain below.

DOWNLOAD WORKBOOK

SumIf_Intro3

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

VLOOKUP Function: Introduction What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP(thi...
MATCH Function Intro The MATCH function in Excel returns the position of an item within a list or a range of cells. Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function. Formula Breakdown: MATCH...
RANDBETWEEN Function I use the RANDBETWEEN function all the time whenever I need to create a sample data set. The cool thing about the RANDBETWEEN function is that if you don't like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downl...
WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday). So if you want to find out on what day you were born, then the WEEKDAY function will remind you. DOWNLOAD WORKBOOK Help...