You may want to copy the formula from the formula bar and past it into your
followup message if you don't get it working.

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

--

Dave Peterson