Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-10-2015, 06:08 PM
ubns ubns is offline COUNTIFS returning Value Error Windows 7 32bit COUNTIFS returning Value Error Office 2010 32bit
Competent Performer
COUNTIFS returning Value Error
Join Date: Apr 2012
Posts: 178
ubns is on a distinguished road
Default COUNTIFS returning Value Error


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?


Umesh Banga
Reply With Quote
Old 04-16-2015, 02:00 PM
Jhnsnkth527 Jhnsnkth527 is offline COUNTIFS returning Value Error Windows 7 64bit COUNTIFS returning Value Error Office 2010 64bit
Join Date: Apr 2015
Location: Cincinnati
Posts: 7
Jhnsnkth527 is on a distinguished road

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_
Reply With Quote

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 returning Value Error Countifs and Sumproduct Algo Excel 6 11-13-2012 07:44 AM
countifs? sonyaturpin Excel 1 05-23-2012 08:29 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:52 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft