I need to count results between two dates from another sheet.
I have dates in column A, I have the words, "Win", "Loss", "Tie" in column B (coinciding w/ the dates in Column A). The dates are for a year. How do I calculate how many wins, loses and ties there are in each month?
*Note... I would like to have it loaded at the beginning of the year so everytime a win,loss or tie is added then it would count it.
Here is a simple example that might get you going:
The dates are in column A and the results are in column B as win, loss or tie.
Formula:
Please Login or Register to view this content.
This will tally the number of wins for January, 2013
You can also enter the start date and end dates in cells for example the start date in F1 and the end date in G1 and win, loss or tie in H1 use this formula:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 03-20-2013 at 04:24 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
The second example worked great! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks