Hello,
Can someone help me come up with a formula for the sheet I have attached? I need to be able to enter a formula in the highlighted cells (B2:C5) that will count the number of occurrences that happen for the month and the letter for which they belong in (A-D).
Thanks a lot,
Arditexample.xlsx
Hi look into attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks Tom. That works good. However is there any way that formula can be altered to ignore non-date cells in the range? The reason I am asking is because my actual data has a few thousand cells that sometimes a non-date cell can sneak into the date column.
Thanks,
Ardit
Maybe it will be good indicator for incorrect value
You would be better off (considering you have a few thousand rows) with this:
Change B1 and C1 to actual dates - Jan 1/12 and Feb 1/12 (format as mmmm) - then in B2
=COUNTIFS($B$11:$B$18,">="&B$1,$B$11:$B$18,"<="&EOMONTH(B$1,0),$A$11:$A$18,$A2)
copied over and down
You should avoid SUMPRODUCT() if more efficient formula is available.
Last edited by Cutter; 04-24-2012 at 11:08 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks