PDA

View Full Version : Solved: countif - help required



Sathisc
06-03-2010, 04:28 AM
Hi,

I just want to calculate count if for particular data

eg:

6/1/10 10:436/1/10 10:436/1/10 10:436/1/10 10:436/1/10 10:436/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:276/1/10 14:27

for this as the time is different the formula is not giving the output.
the date format cant be changed as well

Help is appreciated
Sathish

mdmackillop
06-03-2010, 04:30 AM
Please post your sample data in a workbook, together with your formulae.

Sathisc
06-03-2010, 04:36 AM
plz find the attached

mdmackillop
06-03-2010, 04:48 AM
Simplest way is to add a "helper" column =INT(D2) and apply your COUNTIF to that.

Sathisc
06-03-2010, 04:56 AM
Thanks mate i will use it

Bob Phillips
06-03-2010, 05:48 AM
You can do it without a helper

=SUMPRODUCT(--(INT($D$2:$D$25)=A2))