Countif Help Needed

  • Thread starter Thread starter Adolfo Urrutia
  • Start date Start date
A

Adolfo Urrutia

Hi, I have build a spreadsheet with positions of assignment that covers
an area from c16:m30. below this area i have listed intividual initials
and am trying to put in a formula to add up the hours each person has
been in position. when I use =counif(c16:m30,"aa") i receive the
correct answwer, but I can not get the other 26 queries to search the
sam earea c16:m30 for the other initials. I do not receive an error but
the formula stays in place without any result. I am new at this!
 
Maybe try this formula .......

=COUNTIF(C16:M30,A1)
and put whatever initials you want in A1 and it should COUNTIF it for
you......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top