countif help
Hi
SUMPRODUCT does not support this kind of wildcards. Try instead
=SUMPRODUCT((B28:B392000)*(ISNUMBER(SEARCH("Best" ,D28:D40))))
--
Regards
Frank Kabel
Frankfurt, Germany
Clint Wagner wrote:
I am using the following formula:
=SUMPRODUCT((B28:B392000)*(D28:D40="*Best*"))
and it gives me #N/A
Is there something wrong with this? I have #'s that range from
2-4000
in column B and Words that do contain "Best"
Any help? I will email file if it helps....
Myrna Larson wrote:
COUNTIF supports only one criterion. You have 2, so no, you can't
use COUNTIF here. You need SUMPRODUCT or an array formula.
On Wed, 28 Jul 2004 13:30:52 -0400, Clint Wagner
wrote:
merjet wrote:
I need help with a countif that will:
Count the number of times that: data in column A 2000 and the
text in column B ="*best*"
=SUMPRODUCT((A:A2000)*(B:B="*best*"))
HTH,
Merjet
That's not helping. Im getting N/A everytime. Cant I use a
COUNTIF?
|