Hi Rob,

Check this:

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Kind regards,

Niek Otten

"systemx" wrote in message
...

Hi all,

Probably a relatively simple question - I'm hoping someone can help.

Basically, I want to write a conditional formula without using an
array.

Something like -

COUNT IF 'worksheet1' A:A = 'worksheet2' A1 AND 'worksheet1' B:B =
"HERE".

I have been playing around with this for some time, and have had little
success. The multiple argument seems to throw me out...in addition there
are currently 1500 rows of data (and growing) so there will be many
occurences of the 'worksheet2' A1 value on worksheet 1.

So basically, the formula will go through each row of data, check to
see if two values match, if they do, check the third value is 'HERE' -
and count +1.

I realise I could use a sumproduct formula - but because of the amount
of data performance loss is terrible so this is not a viable option.

Any ideas?

Thank you

Rob


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=525182