Hi and welcome to the forum.
An easy way to do this, is using a helper & hidden column(Let's say C)
sO IN c2 and copy down put this.
=COUNTIF(B2:B3,B2)
Then, use this formula to get your result.
=COUNTIFS(A2:A13,"y",C2:C13,1)
Is this, works, for you?
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.
Wow I`m impressed. That were probably the fastest responses I ever got in a forum and with exactly the answer I was looking for. Thank heaps to both of you.
Alohaey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks