| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple criteria countif/sumproduct function
Hi, I am trying to count criteria from two different columns and have the answer appear on a different worksheet. Here is the formula I have used: =SUMPRODUCT(--('MAIN'!C2:C65534="Phase 2"),--('MAIN'!B2:B65534="Downstairs")) I cannot get it to work on another worksheet within the same workbook! Am I trying the impossible? Any help would be appreciated:) -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564241 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Index function using multiple values in one cell | Excel Worksheet Functions | |||
| Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| creating a function with multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
