PDA

View Full Version : Solved: How to auto count a data



winxmun
09-21-2008, 07:55 PM
Hi,

May I know how to do a count with the data provided as follow:

Ref No. Date
HDB/Pur/153 01/09/08
HDB/Ref/153 02/09/08
PHL/Pur/153 01/09/08
PHL/Ref/153 02/09/08
PHL/Pur/154 01/09/08

System to auto count as follow:
HDB
Date No. of appln
01/09/08 1
02/09/08 1

PHL
Date No. of appln
01/09/08 2
02/09/08 1
:dunno

Bob Phillips
09-22-2008, 12:13 AM
=SUMPRODUCT(--(LEFT($A$1:$A$6,3)="HDB"),--($B$1:$B$6=--"2008-09-01"))

etc.

winxmun
09-27-2008, 08:26 AM
Hi xld,

I've tried using your formula & it works perfectly! tks a lot!:friends:
by the way, i'm curious, what is the "--" for?

Bob Phillips
09-27-2008, 10:03 AM
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation.

winxmun
09-29-2008, 04:29 AM
okie! tks a lot!