[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Using Countif for Variable Search Criterea in Excel

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
bpfsr
Asked:
bpfsr
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Whilst you are sending the file try changing A2:G5014 to $A$2:$G$5014
0
 
bpfsrAuthor Commented:
yup, forgot the file... SP2.xlsm
0
 
Saqib Husain, SyedEngineerCommented:
enter this formula in P2 and copy down

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now