Count of times a number is repeated by date?

B

bjkeyt

My spreadsheet has a record of every time a problems exsists. Problems are
classified by numbers 1-9.
A date may occur more than onces on the spread sheet, a classification may
occur more than onceon a date.
I need to summarized;
how many times a date occurs in spread sheet then how many times a
classification occures on that date.
 
P

PCLIVE

Where:
D1= the date you want to match
D2= the number (1-9)

=SUMPRODUCT(--(A2:A100=D1),--(B2:B100=D2))

HTH,
Paul
 

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

counting the occurrence of specific text within a date range 4
Count if statement 3
Count the number of times a cell value is within a specific range 4
How can I count the frequency that a number is repeated? 1
how do i create a formula in Excel - count by a specific date 4
Counting items with a specific quanitifier in a date range 3
Count the number of times a name occurs in a column 2
Your help please in updating a column using Count or an Array Formula 3

Top