What doesn't work? What results do you get? The formula is perfectly valid
and my test worked O.K.

"Cobbcouk" wrote:


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