Problem with COUNTIF

C

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??
 
G

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
 
C

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.
 
Top