Counting occurrences

Column A3:A13 each cell has a date in it. Column B3:B13 has someones name in each cell. At B16:B26 I want it to validate each entry in column B3:B13 and if the adjacent date in column A3:A13 is later than todays system date then I want it to count the name in column B. The objective is to list everyones name in column A16:A26 and list in column B16:B26 a counting of how many times their name appeared in B3 thru B13 but only if the date has already gone by. I can't figure out what to put in each cell at B16:B26 to make it evaluate the date and count the B3:B13 cells. Does anyone know how I can do that?

Column A3:A13 each cell has a date in it. Column B3:B13 has someones name in each cell. At B16:B26 I want it to validate each entry in column B3:B13 and if the adjacent date in column A3:A13 is later than todays system date then I want it to count the name in column B. The objective is to list everyones name in column A16:A26 and list in column B16:B26 a counting of how many times their name appeared in B3 thru B13 but only if the date has already gone by. I can't figure out what to put in each cell at B16:B26 to make it evaluate the date and count the B3:B13 cells. Does anyone know how I can do that?

Maybe it's cheating, but I would create a third column that tested to see if the date in Column A in that row has already gone by. If so, it would pull the name from Column B; if not, it would be blank. Then you can easily do a COUNTIF using that column (which you can then hide).

Better answer: =SUMPRODUCT((b$3:b$13="Bill")*(a$3:a$13<=today()))

Or this without helper column:

In C16 write:

=SUMPRODUCT(--($A$3:$A$13<TODAY()),--($B$3:$B$13=A16))

For XL2007 and latter it's better to use COUNTIFS formula thne SUMPRODUCT

=COUNTIFS($A$3:$A$13, "<"&TODAY(), $B$3:$B$13, A16)

Thanks Don

There might also be a communication problem with landlines.
All Broadband failed, to my knowledge, in N. England, Scotland, & N. Ireland from about 19:00 yesterday until, BT claimed 08:00 today, my system wasn't restored until 11:30.
The failure coincided with a double circuit trip on the east coast interconnector, how much more tripped after this I don't know yet, but I do know that Manchester was down.

Where do you find a "prefix" box?