Solved

Using Countif for Variable Search Criterea in Excel

Posted on 2011-03-24
3
235 Views
Last Modified: 2012-05-11
For the attached Excel sheet I would like the countif formula in P1 to be copied down column P, however I would like the formula to use whatever value is in Column O (same line) as a variable and return the value in Column Q (same line). The search area will always remain the same - A2:G5014.
0
Comment
Question by:bpfsr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35212476
Whilst you are sending the file try changing A2:G5014 to $A$2:$G$5014
0
 

Author Comment

by:bpfsr
ID: 35212484
yup, forgot the file... SP2.xlsm
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 35212497
enter this formula in P2 and copy down

=COUNTIF($A$2:$G$5014,"*"&O2&"*")
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question