Hi

Replace D28:D40 with D28:D39 so that the range in Column B is matched.
--

Regards

Pete

"Clint Wagner" wrote in message
...
| 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?
|
|