software

I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I
have the sum to count each individually. I now need to be able, in column F,
to count the Y and N, split out by T8, T9 and T10 (column C). I've tried
counta and countif, putting in different parameters but it doesn't work.
I also in column H need to count the Y's again split out by T8, T9 and T10
and in column I (where I have dates) need to count them by T8, T9 and T10.
Help please

Sheila

Not sure what you mean by split out but maybe something like this:

=SUMPRODUCT((C1:C100=quot;T9quot;)*(F1:F100=quot;Yquot;))

quot;Sheila Innesquot; wrote:

gt; I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I
gt; have the sum to count each individually. I now need to be able, in column F,
gt; to count the Y and N, split out by T8, T9 and T10 (column C). I've tried
gt; counta and countif, putting in different parameters but it doesn't work.
gt; I also in column H need to count the Y's again split out by T8, T9 and T10
gt; and in column I (where I have dates) need to count them by T8, T9 and T10.
gt; Help please
gt;
gt; Sheila

Hi

No, that gave me 0, then when I changed 100 to 739 (which is how far the
columns go down, I got N/A.

By split out, I mean separated so that I have individual counts for each,
e.g. T8, 320 T9, 275 T10, 105

quot;pinmasterquot; wrote:

gt; Not sure what you mean by split out but maybe something like this:
gt;
gt; =SUMPRODUCT((C1:C100=quot;T9quot;)*(F1:F100=quot;Yquot;))
gt;
gt; quot;Sheila Innesquot; wrote:
gt;
gt; gt; I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I
gt; gt; have the sum to count each individually. I now need to be able, in column F,
gt; gt; to count the Y and N, split out by T8, T9 and T10 (column C). I've tried
gt; gt; counta and countif, putting in different parameters but it doesn't work.
gt; gt; I also in column H need to count the Y's again split out by T8, T9 and T10
gt; gt; and in column I (where I have dates) need to count them by T8, T9 and T10.
gt; gt; Help please
gt; gt;
gt; gt; Sheila

#N/A usually means that the ranges are not the same size, or the data
contains #N/A. Either needs to be corrected.

Pinmaster's formula was for one specific instance, you would need to have
new for each instance. Maybe better to store the test values T8, T9, etc. in
say M1:M10 and then in N1 add

=SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739=quot;Yquot;))

and copy down to get all the answers

Or use a pivot table.--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Sheila Innesquot; gt; wrote in message
...
gt; Hi
gt;
gt; No, that gave me 0, then when I changed 100 to 739 (which is how far the
gt; columns go down, I got N/A.
gt;
gt; By split out, I mean separated so that I have individual counts for each,
gt; e.g. T8, 320 T9, 275 T10, 105
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt; Not sure what you mean by split out but maybe something like this:
gt; gt;
gt; gt; =SUMPRODUCT((C1:C100=quot;T9quot;)*(F1:F100=quot;Yquot;))
gt; gt;
gt; gt; quot;Sheila Innesquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with T8, T9 and T10 in a single column, Column C.
I
gt; gt; gt; have the sum to count each individually. I now need to be able, in
column F,
gt; gt; gt; to count the Y and N, split out by T8, T9 and T10 (column C). I've
tried
gt; gt; gt; counta and countif, putting in different parameters but it doesn't
work.
gt; gt; gt; I also in column H need to count the Y's again split out by T8, T9 and
T10
gt; gt; gt; and in column I (where I have dates) need to count them by T8, T9 and
T10.
gt; gt; gt; Help please
gt; gt; gt;
gt; gt; gt; Sheila
Hi Bob

No that didn't work either. I got an error messge up that there was a fault
in the calculation and should they fix it. I said yes and ended up with 0
again.

quot;Bob Phillipsquot; wrote:

gt; #N/A usually means that the ranges are not the same size, or the data
gt; contains #N/A. Either needs to be corrected.
gt;
gt; Pinmaster's formula was for one specific instance, you would need to have
gt; new for each instance. Maybe better to store the test values T8, T9, etc. in
gt; say M1:M10 and then in N1 add
gt;
gt; =SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739=quot;Yquot;))
gt;
gt; and copy down to get all the answers
gt;
gt; Or use a pivot table.
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Sheila Innesquot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; No, that gave me 0, then when I changed 100 to 739 (which is how far the
gt; gt; columns go down, I got N/A.
gt; gt;
gt; gt; By split out, I mean separated so that I have individual counts for each,
gt; gt; e.g. T8, 320 T9, 275 T10, 105
gt; gt;
gt; gt; quot;pinmasterquot; wrote:
gt; gt;
gt; gt; gt; Not sure what you mean by split out but maybe something like this:
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT((C1:C100=quot;T9quot;)*(F1:F100=quot;Yquot;))
gt; gt; gt;
gt; gt; gt; quot;Sheila Innesquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet with T8, T9 and T10 in a single column, Column C.
gt; I
gt; gt; gt; gt; have the sum to count each individually. I now need to be able, in
gt; column F,
gt; gt; gt; gt; to count the Y and N, split out by T8, T9 and T10 (column C). I've
gt; tried
gt; gt; gt; gt; counta and countif, putting in different parameters but it doesn't
gt; work.
gt; gt; gt; gt; I also in column H need to count the Y's again split out by T8, T9 and
gt; T10
gt; gt; gt; gt; and in column I (where I have dates) need to count them by T8, T9 and
gt; T10.
gt; gt; gt; gt; Help please
gt; gt; gt; gt;
gt; gt; gt; gt; Sheila
gt;
gt;
gt;

I had one too many brackets in it, that is why.

Can you post me your workbook?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Sheila Innesquot; gt; wrote in message
...
gt; Hi Bob
gt;
gt; No that didn't work either. I got an error messge up that there was a
fault
gt; in the calculation and should they fix it. I said yes and ended up with 0
gt; again.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; #N/A usually means that the ranges are not the same size, or the data
gt; gt; contains #N/A. Either needs to be corrected.
gt; gt;
gt; gt; Pinmaster's formula was for one specific instance, you would need to
have
gt; gt; new for each instance. Maybe better to store the test values T8, T9,
etc. in
gt; gt; say M1:M10 and then in N1 add
gt; gt;
gt; gt; =SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739=quot;Yquot;))
gt; gt;
gt; gt; and copy down to get all the answers
gt; gt;
gt; gt; Or use a pivot table.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Sheila Innesquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; No, that gave me 0, then when I changed 100 to 739 (which is how far
the
gt; gt; gt; columns go down, I got N/A.
gt; gt; gt;
gt; gt; gt; By split out, I mean separated so that I have individual counts for
each,
gt; gt; gt; e.g. T8, 320 T9, 275 T10, 105
gt; gt; gt;
gt; gt; gt; quot;pinmasterquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Not sure what you mean by split out but maybe something like this:
gt; gt; gt; gt;
gt; gt; gt; gt; =SUMPRODUCT((C1:C100=quot;T9quot;)*(F1:F100=quot;Yquot;))
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Sheila Innesquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a spreadsheet with T8, T9 and T10 in a single column,
Column C.
gt; gt; I
gt; gt; gt; gt; gt; have the sum to count each individually. I now need to be able,
in
gt; gt; column F,
gt; gt; gt; gt; gt; to count the Y and N, split out by T8, T9 and T10 (column C).
I've
gt; gt; tried
gt; gt; gt; gt; gt; counta and countif, putting in different parameters but it doesn't
gt; gt; work.
gt; gt; gt; gt; gt; I also in column H need to count the Y's again split out by T8, T9
and
gt; gt; T10
gt; gt; gt; gt; gt; and in column I (where I have dates) need to count them by T8, T9
and
gt; gt; T10.
gt; gt; gt; gt; gt; Help please
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sheila
gt; gt;
gt; gt;
gt; gt;