Hi,
I have a spread sheet with data in the example of;
COLA COLB
Place1 Y
Place1 N
Place2 Y
Place1 Y
Place1 N
Place3 Y
Place1 Y
In a separate Tab I have the Places i.e
Place1
Place2
I would like to count the Y or N for each please, any ideas?
Hi,
I have a spread sheet with data in the example of;
COLA COLB
Place1 Y
Place1 N
Place2 Y
Place1 Y
Place1 N
Place3 Y
Place1 Y
In a separate Tab I have the Places i.e
Place1
Place2
I would like to count the Y or N for each please, any ideas?
Try with COUNTIFS.
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.
Thanks, but don't think that will give me the result I need.
Yes will do.
=COUNTIFS(Sheet1!A1:A100,A2,Sheet1!B1:B100,"Y")
Or else,pls upload a sample workbook.
Fotis is correct for 2007 and above.
If you want/need the result to work with all versions of Excel try this
Formula:Please Login or Register to view this content.
See this 2003 workbook
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks, that works a treat, must have done it wrong before
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks