#1
|
|||
|
|||
COUNTIFS returning Value Error
Hi,
I have countfs form =COUNTIFS(Project_and_BAU_PriorityColumn,"<>"&"",P roject_and_BAU_PriorityColumn,"<>Low",Project_and_ BAU_PriorityColumn,"<>Med",Project_and_BAU_Status_ Column,"<>Completed",Project_and_BAU_Status_Column ,"<>Aborted") It uses two ranges Project_and_BaU_Priority Column and second - Project_and_BAU_Status_Column when I delete the second range and enter cells values of the range lets say $c$5:$c$1000 it works fine and returns the desired result. However I think something is making it confuse if I use the range name Project_and_BAU_Status_Column. Any idea why? Regards Umesh Banga |
#2
|
|||
|
|||
I can't tell if you copied the exact formula that gives you problems, but I get concerned with long named ranges and dealing with spaces.
Project_and_ BAU_PriorityColumn,"<>Med" . . . has a space after and_ Project_and_BAU_Status_ Column,"<>Completed" . . . . has a space after Status_ |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help building COUNTIFS solution | 676nova | Excel | 9 | 02-27-2015 12:50 PM |
COUNTIFS Help Needed | OTPM | Excel | 2 | 04-09-2014 08:32 AM |
Compound Countifs Query not working | Lonercom | Excel | 5 | 06-28-2013 10:27 AM |
Countifs and Sumproduct | Algo | Excel | 6 | 11-13-2012 07:44 AM |
countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |