Countif problem - very weird
I have been given a spreadsheet for me to fix as a countif function wasn't working and it has me baffled!!
Countif usually just works, it is very simple.
All that is happening on the sheet is a countif running down a whole column on another sheet in the workbook and counting the relevant data
=COUNTIF(Q000!$AH:$AH,Data!J1&"Y")
The formula above counts the word "sepy"
There are only 6 instances or sepy in the column but it gives the answer of 5!!
The problem is just in one cell on the Q000 sheet (cell AH204)
Its not counting "sepy" in that cell.
Why? You tell me!!
I have removed formatting from the cell, done Edit > Clear > All and then put the value back in but still nothing
Any help on this would be great
Can we see the sheet?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Without seeing the sheet it would be hard to tell why.
A common error which I have come across with countif is maybe with your word - sepy - there is a space before/after the word.
Hi Guys,
Thanks for the swift reply.
Please see the attached.
There is a comment shown on the Data sheet and what its not counting.
Last edited by turbofatty; 10-28-2009 at 09:12 AM.
Y204 has an extra space after the "Y"
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Just as i expected!!
Re: Countif problem - very weird
Nooooooooooooooooooooooo!!!!
I checked the month (Oct, Sep, etc) but not the Y's.
Why would someone do that??
Damn end users!!!
Many Thanks Guys for the swift turnaround
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks