sum two col one of which is a date.
Hi MusicMan,
You can try
Given in column A the names and in B the dates, in H1 your reference date.
=SUM((A1:A4="JP")*(B1:B4<=H1))
You have to enter this as an array function: ctrl+shift+enter.
Wkr,
JP
"MusicMan" wrote in message
...
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.
|