Years - COUNTIF and SUMIF Regular Reformulated Gas Price...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COUNTIF and SUMIF Regular Reformulated Gas Price Boston, MA Count IF Sum IF Average IF Year Date 2005 52 11736.1 #NAME? 2005January 3, 2005 181.8 2006 52 13328.3 #NAME? 2005January 10, 2005 179.3 2007 53 14363.5 #NAME? 2005January 17, 2005 180 2008 52 16494.5 #NAME? 2005January 24, 2005 182.9 2009 20 3801.3 #NAME? 2005January 31, 2005 189.8 2005February 7, 2005 190.6 2005February 14, 2005 189.5 2005February 21, 2005 188.7 2005February 28, 2005 187.4 2005March 7, 2005 195.3 2005March 14, 2005 197 2005March 21, 2005 200.9 2005March 28, 2005 205.1 2005April 4, 2005 211.6 2005April 11, 2005 217.3 2005April 18, 2005 215.3 2005April 25, 2005 219.3 2005May 2, 2005 220 2005May 9, 2005 218.3 2005May 16, 2005 216.8 2005May 23, 2005 213.8 2005May 30, 2005 210.1 2005June 6, 2005 211 2005June 13, 2005 213.5 2005June 20, 2005 218.7 2005June 27, 2005 221.5 2005July 4, 2005 225.1 2005July 11, 2005 238.8 2005July 18, 2005 238.3 2005July 25, 2005 236.8 2005August 1, 2005 236.9 2005August 8, 2005 239.4 2005August 15, 2005 255.1 2005August 22, 2005 260.6 2005August 29, 2005 260.6 2005September 5, 2005 320.7 2005September 12, 2005 310.8 2005September 19, 2005 293 2005September 26, 2005 286.6 2005October 3, 2005 288 2005October 10, 2005 279.3 2005October 17, 2005 267.2 2005October 24, 2005 255.5 2005October 31, 2005 244.1 2005November 7, 2005 232.7 2005November 14, 2005 221.2 2005November 21, 2005 210.4 2005November 28, 2005 205 2005December 5, 2005 205.8 2005December 12, 2005 212.3 2005December 19, 2005 218.5 2005December 26, 2005 217.9 2006January 2, 2006 222.7 2006January 9, 2006 233.2 2006January 16, 2006 235.1 2006January 23, 2006 237.1 2006January 30, 2006 236.8 2006February 6, 2006...
View Full Document

This note was uploaded on 01/29/2012 for the course COMPUTING 12042 taught by Professor Martinester during the Spring '09 term at Simon Fraser.

Ask a homework question - tutors are online