I have a tstamp column, looks like what I pasted below. How do I write a formula that will give me the total count of tstamp for say 4/1/2011? I want a total count of all the tstamp entries that have 4/1/2011.
Probably an easier way than this but here goes, if your data is in column A then in Column B use, =INT(A1) and fill down. You can then do your countif off this so =COUNTIF(B:B,$C$1) if you put the value you want to search in a cell C1.
Select from the drop-down in the yellow cell to change the results
Hope this helps
[EDIT]
Added COUNTIFS to the attachment.
Last edited by Marcol; 04-13-2011 at 12:58 PM.
Reason: 2007 and above solution added to attachment
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
OR
=SUMPRODUCT(--(INT($A$1:$A$500)=C1))
where C1 contains your date
ChemistB My 2¢
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Bookmarks