Problem with using countifs
I cant seem to get the function below to work. Basically, I am trying get count if the value in one cell in another sheet is either "Yes" or "na". I do have a work-around using sum of separate countif statements but would like to know why the function below is not working for me.
Thanks in advance.
=COUNTIFS(Sheet1!G2:G69,"Yes",Sheet1!G2:G69,"na")
You don't add the range which need to count.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi alb2p,
Your formula looks like you want to count all the cells that have "Yes" in them and at the same time have "na" in them. I'd expect you get an answer of zero.
What do you expect as an answer?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello MarvinP - I tried using OR but that did not work either (see below). the expected answer is to count if the cell is either "Yes" or "na".
Hello oeldere - isnt the syntax for COUNTIFS - =countifs(criteria_range1,criteria,[criteria_range2,criteria],......)=COUNTIF(Sheet1!G2:G69,OR("Yes","na"))
Last edited by alb2p; 01-11-2013 at 02:36 PM.
Hi alb2p
How about:
Formula:
=SUMPRODUCT(--(Sheet1!G2:G69="Yes")+(Sheet1!G2:G69="na"))
Regards Kevin
Merged Cells (They are the work of the devil!!!)
How about:-
=COUNTIF(Sheet1!G2:G69,"Yes")+COUNTIF(Sheet1!G2:G69,"N/A")
I may have completly misread the OP requirment here
Regards
Hello crispybadger - I tried this as well and it also worke. Thank you very much.
Hello Kevin - This worked brilliantly!!! Thanks.
You can also use this version
=SUM(COUNTIF(Sheet1!G2:G69,{"Yes","na"}))
Audere est facere
Hi alb2p
Thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks