# Thread: COUNT/SUM (IF) (MS-2003)

1. ## COUNT/SUM (IF) (MS-2003)

the sample of my question is explained in the attachment, appreciate your help.

2. ## Re: COUNT/SUM (IF) (MS-2003)

Can you explain what you mean by
<hr>Counting and/or summing the number of "Y","N","YY","NN",Y/N" in the array C7:S205
based on the first letter in column Y1, the "A","N","U"<hr>
Perhaps give an example of what the result should be?

3. ## Re: COUNT/SUM (IF) (MS-2003)

In the referenced array I want to count how many y/n, n, nn, y, yy there is based on the first letter in column B1. Column B1 has many names the common between the names is the first letter before the /, for example A /, N/ & U/.

Did I succeed?

4. ## Re: COUNT/SUM (IF) (MS-2003)

No.

Can you explain where you want the results, and what they should look like?

5. ## Re: COUNT/SUM (IF) (MS-2003)

Here is a way, it requires some intermediate formulas:

In W1:AA1 enter respectively, the text: Y, N, Y/N, NN, YY

In V7 enter:
<pre>=LEFT(B7,1)</pre>

In W7:
<pre>=COUNTIF(\$C7:\$S7,W\$1)</pre>

Copy W7 to X7:AA7
Copy V7:AA7 to V8:AA205

This determines the starting letter and sums the number of each type for each row of data.

in V2:V4 enter respectively the text: A, N, U
In W2 enter:
<pre>=SUMIF(\$V\$7:\$V\$205,\$V2,W\$7:W\$205)</pre>

Copy W2 to W2:AA4

This "table" (V1:AA4) should give the sum of the values you are looking for.

Steve

6. ## Re: COUNT/SUM (IF) (MS-2003)

sorry for the in-clarity,
in the same sheet and/or in adifferent one,how they should look like is for A/ in the name A / Fox, J. P. of coloumn B1
y/n n nn yy y
A/ 4

7. ## Re: COUNT/SUM (IF) (MS-2003)

Take a look at Steve (sdckapr)'s reply, I think he understood your question better than I do.

8. ## Re: COUNT/SUM (IF) (MS-2003)

STEVE,
Perfect, and many thanks.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•