software

Hoping someone can guide me in this task....

I have a column that contains 4 different types of items (calling them
letters to make easier: Q, A, P, L)

I need to have a cell at the bottom that basically creates a total count of
each item but only if they are certain items. For example here's a sample
column: and I only want A's and P's counted to make the total.

A
Q
Q
P
L
L
A

(the cell would count 2a's, 1p and the number 3 would show up in the total
column)

Is there a formula that would help with this (I'm assuming some sort of If
statement)

thanks for taking the time to read this.Assuming that A2:A8 contains your data, try...

=SUMPRODUCT(--ISNUMBER(MATCH(A2:A8,{quot;Aquot;,quot;Pquot;},0)))

or

=SUMPRODUCT(--ISNUMBER(MATCH(A2:A8,B2:B3,0)))

....where B2:B3 contains A and P.

Hope this helps!

In article gt;,
Chris gt; wrote:

gt; Hoping someone can guide me in this task....
gt;
gt; I have a column that contains 4 different types of items (calling them
gt; letters to make easier: Q, A, P, L)
gt;
gt; I need to have a cell at the bottom that basically creates a total count of
gt; each item but only if they are certain items. For example here's a sample
gt; column: and I only want A's and P's counted to make the total.
gt;
gt; A
gt; Q
gt; Q
gt; P
gt; L
gt; L
gt; A
gt;
gt; (the cell would count 2a's, 1p and the number 3 would show up in the total
gt; column)
gt;
gt; Is there a formula that would help with this (I'm assuming some sort of If
gt; statement)
gt;
gt; thanks for taking the time to read this.

This may be a bit cumbersome but try this (assuming A1 is your start point)

=COUNTIF(A1:A7,quot;aquot;) COUNTIF(A1:A7,quot;Pquot;)

Tel

quot;Chrisquot; wrote:

gt; Hoping someone can guide me in this task....
gt;
gt; I have a column that contains 4 different types of items (calling them
gt; letters to make easier: Q, A, P, L)
gt;
gt; I need to have a cell at the bottom that basically creates a total count of
gt; each item but only if they are certain items. For example here's a sample
gt; column: and I only want A's and P's counted to make the total.
gt;
gt; A
gt; Q
gt; Q
gt; P
gt; L
gt; L
gt; A
gt;
gt; (the cell would count 2a's, 1p and the number 3 would show up in the total
gt; column)
gt;
gt; Is there a formula that would help with this (I'm assuming some sort of If
gt; statement)
gt;
gt; thanks for taking the time to read this.
gt;