I would like to track and count data from each month by a specific person.
Date data was entered in one column and person who submitted in separate
column. Can anyone help to create a formula? I was able to create a formula
to track the data by month, but not able to set up the second criteria
(person who submitted data).

If numeric dates like 01/01/06 etc

=SUMPRODUCT(--(MONTH(A2:A50)=5),--(B2:B50="John"))

will count John when month is May

if text months like May, June etc

=SUMPRODUCT(--(A2:A50="May"),--(B2:B50="John"))


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Scott" <(E-Mail Removed)> wrote in message
news:F6F52AF3-617A-4759-9FFA-(E-Mail Removed)...
>I would like to track and count data from each month by a specific person.
> Date data was entered in one column and person who submitted in separate
> column. Can anyone help to create a formula? I was able to create a
> formula
> to track the data by month, but not able to set up the second criteria
> (person who submitted data).