in Excel 2010, how can i use countifS to count the number of times column 'B' has initials "EG" AND column 'D' has the word "yes". The problem is that column D has the word "yes" along with other characters such as "TR/yes".
my formula is currently =COUNTIFS(B10:B3000,I1,D10:D3000,"yes")
not working
kindest thanks,
Eddie
Try using wildcards:
=COUNTIFS(B10:B3000,I1,D10:D3000,"*yes*")
Remember what the dormouse said
Feed your head
Try this...
=COUNTIFS(B10:B3000,I1,D10:D3000,"*yes")
edit: is there an echo on here Rory? lol
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
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Looks like it, Ford!
Cross-post here: http://www.mrexcel.com/forum/excel-q...-notice-s.html
Last edited by romperstomper; 09-17-2014 at 11:38 AM.
the asterisks worked perfect. thank you !
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks