SumIf
in [Functions]
|
From: Debi on 14 Apr 2010 05:11 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.....
From: Mike H on 14 Apr 2010 05:19 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.....
From: Debi on 14 Apr 2010 05:23 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.....
From: Mike H on 14 Apr 2010 05:25 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.....
|
Pages: 1 Prev: Sumproduct with sumif over mutiple worksheets Next: Ad-In Rowliner |