| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count of times a number is repeated by date?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count the frequency that a number is repeated? | Excel Worksheet Functions | |||
| how to count maximum number of lines repeated for a site | Excel Worksheet Functions | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Threaded Mode
