Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Match Fomulas?
I've got a few sheets in my workbook.
One sheet (titled Open Documents)I have imported from another program which tells me document numbers, titles, originator or responsible person (this column lists multiple people in one row), dates opened and closed, type of document, etc. I'd like to be able to import this sheet on a regular basis with up to date information, so I don't want to enter formulas here. Another sheet where I am entering my formulas, I have peoples names listed and a column with a function that counts each time a person's name appears in the first sheet. I did that with this function: =COUNTIF('Open Documents'!C:C,"*"&A1&"*") On a third sheet (titled Open Important Documents) I have a list of important documents that are not annotated as such on the first spreadsheet. My question is: How do I count the number of important documents assigned to each person? Basically, once it finds the documents assigned to one person, I'd like it to check those rows for the document number and count them if the document number is found on the third sheet as well. I'm sure the Countif function I entered above will be part of the formula, but I'm not sure if I use sumproduct, match, lookup or a combination of those to get my results. Thanks in advance, Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells that match 2 criteria | Excel Discussion (Misc queries) | |||
Counting instances that 2 different columns match | Excel Worksheet Functions | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Counting when both match | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |