Capture.PNG
I am trying to get a formula in all cells in column D that will look to see if the Name in column B is either John F or Mary F AND falls within the same date and are the same age and return the count. As you can see for 1/2/14 - John F and Mary F are both 15 years old and they both have a date of 1/2/14. The same goes for rows 6 and 8.
Bookmarks