sum two col one of which is a date.
=SUMPRODUCT(--(A2:A7="john"),--(B2:B7<A1))
where john is the name youre searching for and cell a1 contains the date you
want it to fall before.
"MusicMan" wrote:
I have two col. one with names, the second with dates.
I need a COUNT of a specific persons dates before xx/xx/xx.
I can count either with countif but fail when I try to combine.
|