Path: ccsf.homeunix.org!ccsf.homeunix.org!news1.wakwak.com!nf1.xephion.ne.jp!onion.ish.org!onodera-news!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!newsgate1.web.ad.jp!news501.nifty.com!not-for-mail
From: "hato" <hatohato@nifty.com>
Newsgroups: fj.comp.applications.excel
Subject: =?iso-2022-jp?B?UmU6IBskQklpJE5DTSRyGyhCMBskQiRLJDkka0p9SyEkQxsoQg==?=
	=?iso-2022-jp?B?GyRCJEYkIiRqJF4kOSQrISkbKEI=?=
Date: Sun, 13 Jul 2003 00:44:45 +0900
Organization: @nifty netnews service
Lines: 18
Message-ID: <bepad8$4ce$1@news511.nifty.com>
References: <bep8pc$752$1@news512.nifty.com> <3F1029FD.CED4D4D1@sky.sannet.ne.jp>
NNTP-Posting-Host: ntkngw011186.kngw.nt.isdn.ppp.infoweb.ne.jp
Mime-Version: 1.0
Content-Type: text/plain;
	charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
X-Trace: news511.nifty.com 1058024680 4494 61.124.49.186 (12 Jul 2003 15:44:40 GMT)
X-Complaints-To: -
NNTP-Posting-Date: Sat, 12 Jul 2003 15:44:40 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
Xref: ccsf.homeunix.org fj.comp.applications.excel:40

ありがとうございます！
挑戦してみます。


"Y.Sone" <y_sone@sky.sannet.ne.jp> wrote in message
news:3F1029FD.CED4D4D1@sky.sannet.ne.jp...

> SUMIF を使えば良いんじゃないですか。
>
> たとえば、D6 から D20 にデータがあるとして、
>
> =SUMIF(D6:D20,">0")
>
> とか。
>
> --
> 曽根庸介