Counting sets of cells based on two parameters

[Bret]

Hello,

We have a spreadsheet that is layed out something like this:

6 Collumns. Collumn A contains certain features of a software product.
Collumn C contains X's, as checkmarks (indicating those features are
present). Collumn F contains comments regarding the features in
collumn A.

The table looks something like this:

A C F

feat1 X comment
feat2 comment
feat3 X

What we need to do is count the NUMBER OF ROWS that contain BOTH an X
in collumn C, and a comment in collumn F. I know how to count the
number of Xs and the number of Comments, but I need to be able to
count rows with BOTH. For intance, in my example, the formula would
equal 1, as only the first row has both a comment AND a checkmark.

I've been doing some reading and it seems like the dcounta formula is
what i'm looking for, but I cant seem to make it work.

Any suggestions would be greatly appreciated.

-Bret

 

[Bob Phillips]

Try

=SUMPRODUCT(--(C2:C200-"X"),--(F2:F200="comment"))

 

[Bret]

Try

=SUMPRODUCT(--(C2:C200-"X"),--(F2:F200="comment"))

--
__________________________________
HTH

Bob















- Show quoted text -

VERY close. Your formula did work the way I asked for it to work
(there is a typo in it, you put a - instead of =, but I fixed it)

That comment field of course does not say "comment", it is actually
where the comments are written, so it will say different things. I
need it to count the rows that have an X as well as anything in that F
collumn. Basically, I'm asking what the wildcard value is to put in
there for anything in that collumn.

A C F

feat1 X something
feat2 something else
feat3 X
feat4 X blah

In this example, I want it to return a value of 2.

=SUMPRODUCT(--(C2:C200="X"),--(F2:F200="**WHAT GOES HERE**"))

 

[Pete_UK]

Your second term could be:

--(F2:F200<>"")

Hope this helps.

Pete

 

[T. Valko]

see your other post