Re: COUNTIF HELP???

Giganews Newsgroups
Subject: Re: COUNTIF HELP???
Posted by:  daddylonglegs (daddylonglegs.27xbny_1147822200.638@excelforum-nospam.com)
Date: Tue, 16 May 2006

For more than one condition SUMPRODUCT can be used

=SUMPRODUCT(--(MONTH(B1:B100)=5),--(S1:S100="CUSTOMER"))

note you can't use whole columns as with COUNTI

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=3048
View this thread:http://www.excelforum.com/showthread.php?threadid=54272

Replies

None

In response to

COUNTIF HELP??? posted by Scott on Tue, 16 May 2006