software

I want a summary count of two criteria. (count if type = a and class =1)

In one column type is stored and in another column Classification is stored.

I want the know how many type a, classification 1 exist

I was trying to use countif, but can't seem to figure out how to do it for
two criteria. can you use AND??

=COUNTIF(Sheet1!E:E,quot;ICquot;)

MT wrote:
gt; I want a summary count of two criteria. (count if type = a and class
gt; =1)
gt;
gt; In one column type is stored and in another column Classification is
gt; stored.
gt;
gt; I want the know how many type a, classification 1 exist
gt;
gt; I was trying to use countif, but can't seem to figure out how to do
gt; it for two criteria. can you use AND??
gt;
gt; =COUNTIF(Sheet1!E:E,quot;ICquot;)

You say that your criteria are a and 1 yet your COUNTIF contains IC???

Are your types and classes in separate columns? If so where?

What actually are your criteria values?
Fluke, but I just happened to look into it this morning!

What you actually want is multiple-condition formula. If you seach Excel
Help under quot;Sumquot;, there is a great explanation of how to Sum using multiple
conditions. I do not know why the multiple-condition formula option does not
show when you seach quot;Countquot;, but it does not.

Basically, the key difference is that you have to use an array formula
(another thing I learned this morning). The most important thing to remember
with an array formula is to use brace brackets {} around the entire formula.
You do this by either manually entering them, or by holding CTRL-SHIFT-ENTER
after you finish typing the formula.

The formula you use should look like this:

{=COUNT(IF(($B$4:$B$8=$A24)*($E$4:$E$8=B$20),$C$4: $C$8))}

Where A24 is the first condition you want met; B4:B8 is the column in which
you want this condition to be found; B20 is the second condition you want
met; E4: E8 is the column you want this condition to be found; C4:C8 is the
column you want counted.

Some items of note: I used reference cells, but if you want the condition to
be a word, you can just type in quot;Applesquot; instead of A24 or B20. Also, I have
found the exact column to be counted (C4:C8) to be somewhat irrelevant so
long as it is any column in your array of data.

Good luck!

quot;MTquot; wrote:

gt; I want a summary count of two criteria. (count if type = a and class =1)
gt;
gt; In one column type is stored and in another column Classification is stored.
gt;
gt; I want the know how many type a, classification 1 exist
gt;
gt; I was trying to use countif, but can't seem to figure out how to do it for
gt; two criteria. can you use AND??
gt;
gt; =COUNTIF(Sheet1!E:E,quot;ICquot;)

Try (changes ranges to suit):

=SUMPRODUCT(--(A1:A5=quot;aquot;),--(B1:B5=1))

quot;jccquot; wrote:

gt; Fluke, but I just happened to look into it this morning!
gt;
gt; What you actually want is multiple-condition formula. If you seach Excel
gt; Help under quot;Sumquot;, there is a great explanation of how to Sum using multiple
gt; conditions. I do not know why the multiple-condition formula option does not
gt; show when you seach quot;Countquot;, but it does not.
gt;
gt; Basically, the key difference is that you have to use an array formula
gt; (another thing I learned this morning). The most important thing to remember
gt; with an array formula is to use brace brackets {} around the entire formula.
gt; You do this by either manually entering them, or by holding CTRL-SHIFT-ENTER
gt; after you finish typing the formula.
gt;
gt; The formula you use should look like this:
gt;
gt; {=COUNT(IF(($B$4:$B$8=$A24)*($E$4:$E$8=B$20),$C$4: $C$8))}
gt;
gt; Where A24 is the first condition you want met; B4:B8 is the column in which
gt; you want this condition to be found; B20 is the second condition you want
gt; met; E4: E8 is the column you want this condition to be found; C4:C8 is the
gt; column you want counted.
gt;
gt; Some items of note: I used reference cells, but if you want the condition to
gt; be a word, you can just type in quot;Applesquot; instead of A24 or B20. Also, I have
gt; found the exact column to be counted (C4:C8) to be somewhat irrelevant so
gt; long as it is any column in your array of data.
gt;
gt; Good luck!
gt;
gt; quot;MTquot; wrote:
gt;
gt; gt; I want a summary count of two criteria. (count if type = a and class =1)
gt; gt;
gt; gt; In one column type is stored and in another column Classification is stored.
gt; gt;
gt; gt; I want the know how many type a, classification 1 exist
gt; gt;
gt; gt; I was trying to use countif, but can't seem to figure out how to do it for
gt; gt; two criteria. can you use AND??
gt; gt;
gt; gt; =COUNTIF(Sheet1!E:E,quot;ICquot;)