Hello,
I am having trouble trying to count data that is between 2 dates. I want to return how many of some value occurs between selected dates (during the first qtr "x" came up "y" times).
I have a spreadsheet here to review.
Thank you!
Hello,
I am having trouble trying to count data that is between 2 dates. I want to return how many of some value occurs between selected dates (during the first qtr "x" came up "y" times).
I have a spreadsheet here to review.
Thank you!
SEE THE ATTACHED FILE
Formatted the Quarter Number with custom format and used some product
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try this, copied down and across...
=COUNTIFS($B$3:$B$18,">="&K$1,$B$3:$B$18,"<"&EDATE(K$1,3),$C$3:$C$18,$E3)
There are only 5 PQ matches for qtr1 , not 6
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That's what I'm talking about! THank you so much, saved me a lot of time.
Work great!
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks