countif help
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?
|