How do I count data with criteria from two separate columns in exc

S

Scott

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).
 
P

Peo Sjoblom

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
 
Top