On 2002-04-23 12:53, Spott wrote:

So far no luck. These are the formulas I've tried:

=COUNT(IF('Metals L2'!E$2:E$999="*sigma*",IF('Metals L2'!A$2:A$999="D1",0)))

=SUM(('Metals L2'!E$2:E$999="*sigma*")*('Metals L2'!A$2:A$999="D1"))

=SUMPRODUCT(('Metals L2'!A$2:A$999="D1")*('Metals L2'!E$2:E$999="*sigma*"))

=SUM(('Metals L2'!E2:E999="*sigma*")*('Metals L2'!A2:A999="D1"))

The result should be 6, these formulas all return 0. I think I entered them all as arrays (CSE)but my brain is getting very tired...

Thanks!

## Like this thread? Share it with others