santeria
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,844
I think I have found just about every permutation of how to count a Cell content when the cell has text in it.
Thing is, I can't seem to find something that will count multiple occuruences of text.
the basic
=COUNTIF(B7:B81,"**")
Covers a sum up of Cells in a Column, where each cell has only one entry, in this case, and entry of an Initial.
and
=SUM((COUNTIF($B$7:$B$81,INDIRECT("B83"))+(COUNTIF($G$7:$G$81,INDIRECT("B83"))+COUNTIF($L$7:$L$81,INDIRECT("B83"))+COUNTIF($Q$7:$Q$81,INDIRECT("B83"))+COUNTIF($V$7:$V$81,INDIRECT("B83")))))
Covers me for specific Initials that occur over a week.
However, Some columns will have cells that have either
AJ,CJ,MM,AH
or
AJ 031904,CJ 031904,MM 031904,AH 031904
Down the entire row.
The Countif formula is what I basically want to do for each Column, wether it is purely initials, or Initials plus date.
And for the Week, I need to Sum Up Initials for each available initial ( currenly 6 variations), and whilst I am looking for Initials at this time, the initials plus the date of the initials entry is also the main possibility.
I suspect an array formula is required, but I can't conceive of how this would be constructed.
But, if a non-array formula is contsructable, then that would work just as well.
Ta
Thing is, I can't seem to find something that will count multiple occuruences of text.
the basic
=COUNTIF(B7:B81,"**")
Covers a sum up of Cells in a Column, where each cell has only one entry, in this case, and entry of an Initial.
and
=SUM((COUNTIF($B$7:$B$81,INDIRECT("B83"))+(COUNTIF($G$7:$G$81,INDIRECT("B83"))+COUNTIF($L$7:$L$81,INDIRECT("B83"))+COUNTIF($Q$7:$Q$81,INDIRECT("B83"))+COUNTIF($V$7:$V$81,INDIRECT("B83")))))
Covers me for specific Initials that occur over a week.
However, Some columns will have cells that have either
AJ,CJ,MM,AH
or
AJ 031904,CJ 031904,MM 031904,AH 031904
Down the entire row.
The Countif formula is what I basically want to do for each Column, wether it is purely initials, or Initials plus date.
And for the Week, I need to Sum Up Initials for each available initial ( currenly 6 variations), and whilst I am looking for Initials at this time, the initials plus the date of the initials entry is also the main possibility.
I suspect an array formula is required, but I can't conceive of how this would be constructed.
But, if a non-array formula is contsructable, then that would work just as well.
Ta