Counting Based on Multiple Criteria

  • Thread starter Thread starter theboatdude
  • Start date Start date
T

theboatdude

Hi Everyone -

OK, here's what it is: I have a spreadsheet that includes, amongs
other information, the date an entry was made and the type of equipmen
it refers to. What I'm looking to do is have an automated report tha
will count based on 2 criteria: the month and the equipment (so
would be able to see how many entries were made on Equipment 1, durin
the month of January, say).

(NOTE: This, btw, is the same spreadsheet that I was referring to i
yesterdays post - just trying to get some different information)

Thanks to all.....C
 
try
=sumproduct((month(a2:a200)=2)*(b2:b200="joe"))
to count
=sumproduct((month(a2:a200)=2)*(b2:b200="joe")*c2:c200)
to sum
 
You must log in or register to reply here.

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 IF multiple criteria 7
Counting based on Date Range 1
count cells with multiple criteria and two rows 2
Distinct Counts with Multiple Criteria 1
Count occurance of multiple text criteria 2
Counting Cells with Multiple Range Criteria (Excel 2003) 7
assign value based on criteria and total 1
Result Based on Date Criteria 6

Back
Top