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.



Helpful Resource:

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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on 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...