LinkBack URL
About LinkBacks
I am new to excel, Can anybody help me to use Countif formula for the following conditions.
Row 1 Yes Yes Yes No (Need the count of "Yes)
Row 2 Yes No No Yes (Need the count of "Yes)
Thanks,
MB
I am new to excel, Can anybody help me to use Countif formula for the following conditions.
Row 1 Yes Yes Yes No (Need the count of "Yes)
Row 2 Yes No No Yes (Need the count of "Yes)
Thanks,
MB
Maybe read here: COUNTIFS function
Syntax for COUNTIF() is...
=COUNTIF(range-to-test, criteria to test for)
So for something like what you showed...
=countif(A1:D1,"Yes")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks