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

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

HTH,
Paul


--

"bjkeyt" wrote in message
...
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.