Formula works for one set of criteria but not the other.
I have a formula that works with one set of criteria, but not the other for some reason. I have attached an example of the file.
Basically, this is a list of sewer and water taps sold. The formula is a simple "countifs" and the criteria is if its a sewer tap sold between July 1 thru July 31, then count it. The formula for the sewer count works perfectly and counts 57 of them. The water formula should count the 8 water accounts, but doesn't. Its the SAME formula with only the one criteria changed. I have checked for extra spaces, I have checked formatting and all of the usual suspects that cause these problems.
Experts-Exc-Example-Formula-Not-wor.xlsx
Basically, this is a list of sewer and water taps sold. The formula is a simple "countifs" and the criteria is if its a sewer tap sold between July 1 thru July 31, then count it. The formula for the sewer count works perfectly and counts 57 of them. The water formula should count the 8 water accounts, but doesn't. Its the SAME formula with only the one criteria changed. I have checked for extra spaces, I have checked formatting and all of the usual suspects that cause these problems.
Experts-Exc-Example-Formula-Not-wor.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rob Henson
The values in rows 59 to 66 for water all have a space after the word water
ASKER
THAT WAS IT! Thank you so much!!!!