I am looking for some help, I have been searching the forums all morning but have failed to come up with a solution so I am looking to the members expertise for help!
Here is a basic setup of my table.
Column A - Dates
Column B - Type (Flat, AW or NH)
Column C - Runner (Horse Names)
Column D - Result (Won, Place or Lost)
Now this is what I am trying to achieve, I want to count the number of rows UNTIL the results column produces "Won" but I have multiple if functions.
The Countifs formula would be =Countifs([Column A],"<"&[@[Column A]],[Column B],[@[Column B]],[@[Column C],[Column C])
This obviously counts the whole workbook, I want it to count only up to the first instance of 'Won' in Column D and the have it reset for the next row and count until the next 'Won' again and so on until the end of the workbook.
For example
20/02/2013 AW Abigails Angel Lost - Count would be 2
11/01/2013 AW Abigails Angel Placed - Count would be 1
27/12/2012 AW Abigails Angel Won - Count would be 5
24/10/2012 AW Abigails Angel Placed - Count would be 4
25/08/2012 AW Abigails Angel Lost - Count would be 3
12/08/2012 AW Abigails Angel Lost - Count would be 2
19/07/2012 AW Abigails Angel Placed - Count would be 1
11/06/2012 AW Abigails Angel Won
Hope I have explained it ok and if not let me know otherwise thank you in advance for any advice/help.
Bookmarks