Count If value

[Kennedy]

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

 

[T. Valko]

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")

 

[FSt1]

hi
countif....
=countif(A1:A20,"Dem")
results = 3
column B has no relevence.

what problems are you haveing?

Regards
FSt1

 

[FSt1]

hi
afterthought..
column B would have relevence if you were using SumIf.

which are we talking about??

regards
FSt1

 

[Kennedy]

Thanks for the replies....
Column B will have relevance in the formula. Specifically, I am counting the
actual number returned. While I onlyu put 1 in column B, the return value
could be 2, 3, 4, etc....
So what I would like to do is say, count all the numbers in column B for the
Dems in column A and ive me a total, then count all the numbers in column B
for Fre and give me a total.

 

[Fred Smith]

You want a Pivot Table. It will do everything you want simply and quickly.

Regards,
Fred

 

[FSt1]

hi
count numbers in B or sum numbers in B? i may still be confused here.
counting instances of Dem in A would be the same counting a number in B that
matches up to Dem in A and B would still have no relevence.
unless you had a situation where you didn't want to count certain numbers
like zeros. use sumproduct then
=SUMPRODUCT((A1:A20="Dem")*(B1:B20<>0))

if your are counting, B should have no relevence.

regards
FSt1

 

[Kennedy]

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]

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.

 

[Kennedy]

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]

You're welcome. Thanks for the feedback!