Hi all,
I was just wondering if anyone could spot what is wrong with this formula:
=COUNTIFS('All households'!$V$2:$V$5263,"Successful",'All households'!$C$2:$D$5263,"Rural")
I keep getting the #VALUE! error.
Thanks beforehand.
Hi all,
I was just wondering if anyone could spot what is wrong with this formula:
=COUNTIFS('All households'!$V$2:$V$5263,"Successful",'All households'!$C$2:$D$5263,"Rural")
I keep getting the #VALUE! error.
Thanks beforehand.
Last edited by undergrad08; 02-08-2022 at 02:27 PM.
From the help file for the COUNTIFS() functionNote that range two is 5262 rows by 2 columns (C2:D5263) where range 1 is 5262 rows by 1 column (V2:V5263). I expect that you intended range two to only be looking at column C, and expect you will get the correct result if you make that edit to the formula.Originally Posted by MS Excel Help
Originally Posted by shg
It is because your second range is two columns wide, whereas your first range is only one column. What exactly are you trying to achieve?
Pete
Thanks!!
Can't believe I didn't see that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks