In the attached file I am trying to display the Win/Loss record from the data dependent on a start and stop year.
Jim O
In the attached file I am trying to display the Win/Loss record from the data dependent on a start and stop year.
Jim O
Last edited by JO505; 01-31-2015 at 11:17 AM.
Your Desired result for 2011 to 2012 for showing only 2011 Data but
Your Desired result for 2012 to 2014 for showing the data of 2012,2013 & 2014
Why 2011-2012 is only 2011
and 2012-2014 is 2012, 2013 & 2014
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Not sure where you got 6 - 3 from?
Try this...
=COUNTIFS($D:$D,">="&P3,$D:$D,"<="&Q3,$H:$H,"W")&" - "&COUNTIFS($D:$D,">="&P3,$D:$D,"<="&Q3,$H:$H,"L")
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
Hope it helps~
Ford,
Again you come through with the solution. Thank you very much for your time.
Jim O
Jim, happy to help (again)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks