| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multifunction formula
I am trying to do a formula that would give me a count for multiple factors
A B Loacation name Event type looking for a count if location= specific name and Event type=specific This is what I have, but is not working. What am I missing. Help.... =COUNT(IF('2008 Events'!C2:C220=Sheet2!A7,IF('2008 Events'!F2:F220=Sheet2!C1,0),0)) -- Thanks, Bobbie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multifunction formula
Try this:
=SUMPRODUCT(--('2008 Events'!C2:C220=Sheet2!A7),--('2008 Events'!F2:F220=Sheet2!C1)) -- Biff Microsoft Excel MVP "Bobbie" wrote in message ... I am trying to do a formula that would give me a count for multiple factors A B Loacation name Event type looking for a count if location= specific name and Event type=specific This is what I have, but is not working. What am I missing. Help.... =COUNT(IF('2008 Events'!C2:C220=Sheet2!A7,IF('2008 Events'!F2:F220=Sheet2!C1,0),0)) -- Thanks, Bobbie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multifunction for one cell | Excel Worksheet Functions | |||
Linear Mode
