Problem with COUNTIF

[Cheryl MM]

I have an attendance calendar that I want to total the V (vacation) days. I
am using =COUNTIF(B7:AG7,"V")
I cannot figure out why this formula is not working. The spreadsheet is a
bit hard to describe so if I can send it to someone to look at, it would
probably be best. Any takers??

 

[Gary''s Student]

The problem must be in the data, not the formula. Your formula counts both
upper and lower case v. It will ignore cells that have a blank before or
after the v. It will ignore cells that contain "victory" or "active".

It counts cells with a single character v or V

 

[Cheryl MM]

If I click on the formula and then press enter, it will work. If I add V to
another cell, it will not count it unless I again click on the formula and
press enter.

 

[Gary''s Student]

Tools > Options > Calculation and then check Automatic.

 

[Cheryl MM]

That worked! Thanks so much! I've been struggling with this for days!