G'day all
I have this formula which works just peachy:
Formula:
Please Login or Register to view this content.
I am trying to add a new criterium as shown:
Formula:Please Login or Register to view this content.
Which returns #VALUE.
Bound to be a simple answer...bit like myself.
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
read here: COUNTIFS()
Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.
COUNTIFS with a single criteria seems to allow a multiple columns in the criteria range, probably because excel may be converting it to a simple countif() function.
=COUNTIFS(AEW:AIV,A6380)
But as soon as you add a 2nd criteria (and range), excel will no longer accept multi-column ranges. 1 criteria - 1 (column or row) range
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Actually, COUNTIFS does accept same-size multi-column ranges but it counts hits only in the columns that have the same relative position in the ranges.
@ Root, thanks for the update. I have never bothered to try that because I knew it would not return what I wanted.
In the test I did for this...
=COUNTIFS(D23:F34,0,G23:G34,0)
returned #VALUE
=COUNTIFS(D23:F34,0,G23:I34,0)
returned 1, when there were far more qualifying entries
It only takes criteria from the 1st column in each range
hm .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks