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

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
--
Gary''s Student - gsnu200762


"Cheryl MM" wrote:

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

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" wrote:

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
--
Gary''s Student - gsnu200762


"Cheryl MM" wrote:

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

Tools Options Calculation and then check Automatic.
--
Gary''s Student - gsnu200762

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

"Gary''s Student" wrote:

Tools Options Calculation and then check Automatic.
--
Gary''s Student - gsnu200762