How to count the amount of times a unique event happens in Excel?

Question

I have a range and I want to count the number of times a value appears in column 1 and no values appear in the other 3 columns on the same row.

Here is an example of the data I'm working with:

So for this data the answer should be 4.

What version of Excel are you using? 2007 & later have a modified version of the `countif` function that allows for multiple criteria. See `countifs`. — Jacob, Jul 08 '14 at 13:25
See http://stackoverflow.com/questions/10158675/count-if-two-criteria-match-excel-formula/21625201#21625201 for approaches that work pre and post [tag:excel-2007] — brettdj, Jul 09 '14 at 01:21

score 1 · Accepted Answer · answered Jul 08 '14 at 13:27

1

Please try:

=COUNTIFS(A:A,"Seen",B:B,"",C:C,"")

answered Jul 08 '14 at 13:27

pnuts

is there a way to make it count any cell that has a value instead of searching `"Seen"`? something that would function like `COUNTA` – Sat Jul 08 '14 at 14:04
that doesn't seem to work for me. http://i.imgur.com/T56YlfQ.png sometimes the value in the 1st column is not "seen" but i still want the formula to count those values. – Sat Jul 08 '14 at 14:19
1

my apologies, so it does :) ty – Sat Jul 08 '14 at 14:29

score 0 · Answer 2 · answered Jul 08 '14 at 13:28

0

Try this:

=COUNTIFS(A:A,"Seen",B:B,"",C:C,"")

answered Jul 08 '14 at 13:28

Jacob

2 Answers2