Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #54

sumif and dates

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.datemas.de!rt.uk.eu.org!aioe.org!.POSTED!not-for-mail
From Dave <dboland9@fastmail.fm>
Newsgroups comp.apps.spreadsheets
Subject sumif and dates
Date Sat, 15 Mar 2014 20:19:17 -0400
Organization Aioe.org NNTP Server
Lines 9
Message-ID <lg2qmm$r2m$1@speranza.aioe.org> (permalink)
NNTP-Posting-Host 02DFi1v3TNstCE8ht1facA.user.speranza.aioe.org
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
User-Agent Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Thunderbird/24.3.0
X-Notice Filtered by postfilter v. 0.8.2
Xref csiph.com comp.apps.spreadsheets:54

Show key headers only | View raw

I have used sumif for reports and it has always worked well, until I 
needed to sum ranges by date (2012, 2013, Jan. 2014, Feb. 2014, etc.). I 
have not been able to get sumif to work with common date formats such as 
1/21/12 or 1/21/2012.  It does work if I segregate the day, month, and 
year in different columns.  Any ideas to make it work, or a good 
work-around?

Thanks,
Dave

Back to comp.apps.spreadsheets | Previous | Next | Find similar

Thread

sumif and dates Dave <dboland9@fastmail.fm> - 2014-03-15 20:19 -0400

csiph-web