M
Mike Copeland
I have a worksheet (of wines I've accumulated over several years) and
I'd like to produce sum totals of prices/costs for each year. I presume
I want to use the sumif function, but I don't know how to use the date
values in the criteria. That is, ">= 1/1/2007 & <= 12/31/2007" doesn't
look like a valid selection value range. How do I use a date field in
this way (or is there a better way?)? TIA
Cabernet Sauvignon Montes` 7.89 09/15/2007
Cabernet Sauvignon Riven Rock 5.99 04/14/2007
Cabernet Sauvignon Robert Mondavi 0.00 12/22/2006
Cabernet Sauvignon Spiral 4.99 12/21/2010
Cabernet Sauvignon Trader Joe's 4.99 12/21/2010
Cabernet Sauvignon Veo Grande 6.98 12/16/2007
Champagne Mumm Napa 13.99 11/27/2007
Champagne Mumm Napa 0.00 12/22/2006
Champagne Tott's 5.97 05/24/2008
I'd like to produce sum totals of prices/costs for each year. I presume
I want to use the sumif function, but I don't know how to use the date
values in the criteria. That is, ">= 1/1/2007 & <= 12/31/2007" doesn't
look like a valid selection value range. How do I use a date field in
this way (or is there a better way?)? TIA
Cabernet Sauvignon Montes` 7.89 09/15/2007
Cabernet Sauvignon Riven Rock 5.99 04/14/2007
Cabernet Sauvignon Robert Mondavi 0.00 12/22/2006
Cabernet Sauvignon Spiral 4.99 12/21/2010
Cabernet Sauvignon Trader Joe's 4.99 12/21/2010
Cabernet Sauvignon Veo Grande 6.98 12/16/2007
Champagne Mumm Napa 13.99 11/27/2007
Champagne Mumm Napa 0.00 12/22/2006
Champagne Tott's 5.97 05/24/2008