Hey guys, I have columns. A, B If I'm using sumproduct as a counting function, I need to set up at least two criterias, right? But, if I want to count all the values in column A where column b has a certain value (I don't care about the value in Column A), how can I do it? In other words, I want to count all values in column A (They can be different) as long as there is a certain value in the row for column B.
Also, How do I modify it to only count DIFFERENT values in column A?
If you still don't understand, here's an example:
[CODE]
A- COlumn 1
A1- Dog
A2- Cat
A3- Horse
A4- Dog
B- column 2
B1- One
B2- One
B3- Two
B4- One
So, I'm looking for 2 versions of sumproduct.
1. Count all values in column A only if column B = One
This would give a result of 3.
2. Count all DIFFERENT values in column A only if column B=One
This would give a result of 2
thx in advance
mgkmn
Bookmarks