Count If value

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
Thanks again,
This worked. The solution by FSt1 also worked for the formula. Just
changed
the columns to have it look at the numbers first, then the "Dem" values.
But
the concept was perfect. Thanks to both of you again, and I have clicked
on
the "Yes" button to show that the answers you two provided worked.

"T. Valko" wrote:

Try something like this...

=SUMPRODUCT(--(A2:A100="Dem"),--(ISNUMBER(B2:B100)))

Adjust the ranges to suit.

Note that with SUMPRODUCT you *can't* use entire columns as range
references
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
Hi Valko,
Here's a better sample of what I am trying to do:
If you look at the sample below, you will see that I am looking at both
the
Net and Area to gather the number. So if the Area has Dem, count all
the
numbers under the Net. If the Area has Fre, count all the numbers under
the
Net associated with Fre. There are several other items in the Area that
I
did
not list here and unfortunately it varies from day to day with the
number
of
values.

Value Month NET Rpt Cnt Count Area Case
1 1 Dem
Elim Feb 0 1 Dem
1 1 Dem
2 1 Dem
Add March 1 1 Fre
3 1 Fre
2 1 Fre
Elim March 0 1 Fre
Elim Feb 0 1 Fre
Elim Feb 0 1 Fre

4 Dem
6 Fre


"T. Valko" wrote:

If column B *always* has a value of 1 then all you need to do is count
the
instances in column A:

=COUNTIF(A:A,"Dem")
=COUNTIF(A:A,"Fre")

=COUNTIF(A2:A100,"Dem")
=COUNTIF(A2:A100,"Fre")

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
Trying to find a way to use a countif value that pulls back specific
count
for certain values in a column. Using countif because the cell
contains
a
computed value that returns a value of 1
So if:
Col A Col B
Dem 1
Dem 1
Dem 1
FRE 1
FRE 1
FRE 1

The countif value would show for Dem 3 and Fre 3



.



.