It's new sibling, SUMIFS() lets you sum values by multiple conditions. This blog post was originally published in November 2011. Summing values that correspond to a specific date is a common Excel task and easily accomplished using SUMIF(). This function totals values that meet a specific condition-a single condition. It won't work if you need to sum values that fall within a specific time period. You could resort to an array, but the newer SUMIFS() function is easier than an array. This function (new to Excel 2007) totals values that meet more than one condition.
King Oliver Biography. Born May 11, 1885, in New Orleans (some sources say Donaldsville), LA; died April 8, 1938, in Savannah, GA. Billed as the World's Greatest Cornetist, Joe King Oliver reigned as the premier trumpeter of jazz during the early 1920s. The famed musical mentor of Louis Armstrong, Oliver is perhaps best remembered for bringing the young New Orleans hornman to Chicago in 1922.
English solider and statesman Oliver Cromwell (1599-1658) was elected to Parliament in 1628 and 1640. The outspoken Puritan helped organize armed forces after the outbreak of civil war in 1642, serving as deputy commander of the âNew Model Armyâ that decimated the main Royalist force at the 1645 Battle of Naseby.