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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count data in adjacent cell if criteria met 0
Multiple Criteria Date Count formula 1
Formula Count dates multiple criteria 3
Counting dates with specific criteria 1
Count if text meets given criteria 2
count cells in a table that meet multiple criteria 1
Sumproduct but only first time corresponding value is seen e.g. un 1
Days Count Sheet Help 5

Back
Top