Path: ccsf.homeunix.org!news.moat.net!news.glorb.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: ludek.pokorny@vw.com
Newsgroups: fj.comp.applications.excel
Subject: Re: Excel - summarise a day - pls help !
Date: 16 Jun 2005 08:36:32 -0700
Organization: http://groups.google.com
Lines: 17
Message-ID: <1118936192.120734.55460@g43g2000cwa.googlegroups.com>
References: <1118086812.791951.219460@g47g2000cwa.googlegroups.com>
NNTP-Posting-Host: 199.5.47.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118936198 2514 127.0.0.1 (16 Jun 2005 15:36:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 16 Jun 2005 15:36:38 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=199.5.47.1;
   posting-account=uupooA0AAAA1dVGYIzTn5zrXIn7HBoTz
Xref: ccsf.homeunix.org fj.comp.applications.excel:259

Hi Vince28,

First of all, today's sales are not 70 but 80. Second, use SUMIF
instead.

6/1/2005	50
6/1/2005	50
6/3/2005	60
6/3/2005	20

CRITERIA	SUMIF

In CRITERIA cell (A6), type: 6/3/2005 (or any other date)
For SUMIF cell (B6) type: =sumif(a1:a4,a6,b1:b4)

Cheers.