Solved: countif - help required
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
Please post your sample data in a workbook, together with your formulae.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
plz find the attached
Simplest way is to add a "helper" column =INT(D2) and apply your COUNTIF to that.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks mate i will use it
You can do it without a helper
=SUMPRODUCT(--(INT($D$2:$D$25)=A2))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
