This doesn't make any sense. It obviously relates to another thread,
so why have you started a new one? You are not going to get any help
just because you say it's urgent.

Pete

On Nov 22, 9:42 am, HighlandRoss
wrote:
I have had the answer to my original question but have a couple of spanners
to throw in to the works!!

The formula is on a different sheet to the data to which the formula
pertains and the set of numbers is actually a formula of say column x * Y.
Can my original query still be done??!?!?

Thanks Loads!!!!!!



another suggestion:
=Sumproduct(--(A1:A4="open"), --(B1:B410))
entered normally

"HighlandRoss" wrote:

Hi
I am trying to work out how to create a formula that reads only entries of
"Open" in column A and counts instances of those with "Open" and a value of
over 10 in column B i.e. a value of 2 should be returned in the example
below. Can anyone please help

Cheers
Ross

A B C D
1open 11
2closed 11
3open 16
4open 7- Hide quoted text -

- Show quoted text -