SumIf
 

I am creating a holiday card for staff in the office and wanted to know if
there is a sumif function for adding up the number of times a specific letter
appears in a row. I have created a calendar using the names of staff (on the
vertical) and the dates (on the horizontal) and now need to put in a function
that will allow me to collect the number of "H" characters (holidays) for
each row.

been at it all morning but I am missing a bracket or a comma somewhere.....

SumIf
 

Hi,

Because they are letters you would count them and not sum them so you can
use COUNTIF

=COUNTIF(A1:J1,"H")

Change the range and drag down as required.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Debi" wrote:

I am creating a holiday card for staff in the office and wanted to know if
there is a sumif function for adding up the number of times a specific letter
appears in a row. I have created a calendar using the names of staff (on the
vertical) and the dates (on the horizontal) and now need to put in a function
that will allow me to collect the number of "H" characters (holidays) for
each row.

been at it all morning but I am missing a bracket or a comma somewhere.....

SumIf
 

YAY - Thanks Mike. All done.

"Mike H" wrote:

Hi,

Because they are letters you would count them and not sum them so you can
use COUNTIF

=COUNTIF(A1:J1,"H")

Change the range and drag down as required.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Debi" wrote:

I am creating a holiday card for staff in the office and wanted to know if
there is a sumif function for adding up the number of times a specific letter
appears in a row. I have created a calendar using the names of staff (on the
vertical) and the dates (on the horizontal) and now need to put in a function
that will allow me to collect the number of "H" characters (holidays) for
each row.

been at it all morning but I am missing a bracket or a comma somewhere.....

SumIf
 

Your welcome
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Debi" wrote:

YAY - Thanks Mike. All done.

"Mike H" wrote:

Hi,

Because they are letters you would count them and not sum them so you can
use COUNTIF

=COUNTIF(A1:J1,"H")

Change the range and drag down as required.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Debi" wrote:

I am creating a holiday card for staff in the office and wanted to know if
there is a sumif function for adding up the number of times a specific letter
appears in a row. I have created a calendar using the names of staff (on the
vertical) and the dates (on the horizontal) and now need to put in a function
that will allow me to collect the number of "H" characters (holidays) for
each row.

been at it all morning but I am missing a bracket or a comma somewhere.....