Smart questions
Smart people
 Find A ForumFind An Expert
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Remember Me

Are you an
Engineering professional?
Join Eng-Tips now!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Just copy and paste the

#### Feedback

"...(I) have been able to get my problems solved from past messages and also new posts that other users have responded to promptly..."

#### Geography

Where in the world do Eng-Tips members come from?

# Excel 2003

 Forum Search FAQs Links Jobs Whitepapers MVPs
 Bollywood (Chemical) 23 Jul 12 11:57
 Primary Secondary F V P T F T L V H Y F V T T X V F I F T T T P V H V Z SC H V F V L V H Y F I Above excel data on "sheet1". On sheet 2 tryin to count say e.g. number of "FV"s. Any suggestion for formula. Thanks.
 FrancisL (Computer) 23 Jul 12 12:09
 Data Pivot Table
 RobD7 (Chemical) 23 Jul 12 13:32
 If you use VBA, you can just do a count for y=1 to 50 IF cells(1,y)=F AND cells(2,y)=V then x=x+1, display x
 pmover (Mechanical) 23 Jul 12 22:02
 if cell values are text in separate columns, then try placing this formula is adjacent column =if(and(a1="F",b1="V"),1,0) if cell values are in same column, the try =if(a1="F V",1,0) you can then sum or count the "ones". crude method, but works. good luck. -pmover
 Latexman (Chemical) 24 Jul 12 7:06
 Bollywood - this question should have went in the Engineering Spreadsheets forum. Red Flag your post and ask management to move it. You may get some other advice/options over there. Good luck, Latexman

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!