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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif with cell ref vs fixed number... 5
IF statement Help 10
Yet, another TIME problem 2
Needing a formula 1
help with vlookup 3
Excel Need Countifs Formula Help 0
how to use countif to incorporate filters 1
Help with Formula 8

Back
Top