good day,
im trying to get a countif to count how many times 77 has "left" in a table. for somereason its comming to 0- if i set 77 to both criteria it then counts all the timews 77 is there(not what i want..lol) why is this not working out? Trying to get the number of times "77" has "left" in the table.
File im working with:
test.xlsx
Could you explain some more please ? As far as I can see the word "left" is present next to each occurrence of the number 77 ?Trying to get the number of times "77" has "left" in the table.
opps,
i left out if left appears in 77, ZZ column, Left counts 1, and the same with the ZA column.
i need to count the total number of "Left" and "right" that are in each column of zz and za for 77 78 79
it's not working because it is cannot see any link between the text and the number. We need to add another step in there i think
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
If you put your data in 3 columns only - 1 set below the other - , then countifs() will work...
No zz za
77 left right
78 right left
79 left left
77 left right
78 right left
79 left left
77 left right
78 right left
79 left left
77 left right
=COUNTIFS($A$2:$A$25,77,$B$2:$B$25,"left")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks