COUNTIF inconsistency

Thanks everyone who replied so quick and with so many suggestions. That really helped me out of a jam.

The field didn't update after I tried some of the fixes suggested, but it is working now and I'm not sure why. I saved a temporary spreadsheet as an XLSX format document (was using XLS by default for compatibility reasons) and that seemed to trigger the refresh in the main doc (which was already saved as XLSX).

I have switched over to use XLSX by default in settings just to be safe.

Originally Posted by martindwilson

post a workbook not an image, but your image has the wrong formula in

Yeah sorry, that was a pretty little-league mistake.

UPDATE: Yes, saving triggers a refresh. Resolved. Thanks again.