=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

COUNTIF

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column B
is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

I have tried transposing countif for sumif but it doesn't work. I have also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

=COUNTIF(B:B,"I") counts the number of Y's in col B.
What are you trying to do?

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have tried transposing countif for sumif but it doesn't work. I have also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column
B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

I have a table that lists when clients are contacted and there response.
I need to collate the information according to the date and the response,
this is why the formula "=SumIf(B:B,23/5/07,C:C) sounded perfect however the
response I am trying to collate is either "Y" or "N"

"Don Guillett" wrote:

=COUNTIF(B:B,"I") counts the number of Y's in col B.
What are you trying to do?

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have tried transposing countif for sumif but it doesn't work. I have also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column
B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

Further to what I have written I have been trying out different things and
came up with the following:
Private Sub Worksheet()
ActiveCell.FormulaR1C1 = _
"=IF(Range(D12:D2000)=""Y"",Range(T12:T2000)=1 "
End Sub
The idea is if I can't get a formula to collate the information the way I
need it to happen then maybe I can try to convert the "Y" into a numeral in a
separate column and then use the sumif formula. I know I can do this
conversion on individual cells but I would rather do it on a field basis as
it occupies less space.

"John D" wrote:

I have a table that lists when clients are contacted and there response.
I need to collate the information according to the date and the response,
this is why the formula "=SumIf(B:B,23/5/07,C:C) sounded perfect however the
response I am trying to collate is either "Y" or "N"

"Don Guillett" wrote:

=COUNTIF(B:B,"I") counts the number of Y's in col B.
What are you trying to do?

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have tried transposing countif for sumif but it doesn't work. I have also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column
B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

You never did give a sample of your layout. IF?? you have dates in col B and
Y/N is col C and you want to COUNT them, then try this keeping in mind that
you cannot use entire columns in the formula. Assumes your date in B1.
=sumproduct((b2:b22=b1)*(c2:c22="Y"))

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have a table that lists when clients are contacted and there response.
I need to collate the information according to the date and the response,
this is why the formula "=SumIf(B:B,23/5/07,C:C) sounded perfect however
the
response I am trying to collate is either "Y" or "N"

"Don Guillett" wrote:

=COUNTIF(B:B,"I") counts the number of Y's in col B.
What are you trying to do?

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have tried transposing countif for sumif but it doesn't work. I have
also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question
and I
believe that it might benefit what I am trying to do however my
column
B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?