<div>
Not sure what you mean by "within Index column A".<br><br>For counting 1:<br>Fromula in C2 =COUNTIF(F2:U2,1)<br>For counting 1 - 3 ( do you mean 2 to 3 as you already have 1)<br>Formula in D2 =COUNTIFS(F2:U2,"&gt;"&amp;1,F2:U2,"&lt;="&amp;3)<br><br>Copy down as required.
</div>


<div>
Hi Rob<br><br>I would like two separate formulas. ie: the formula in D col should include 1,2 and 3<br>Can you please add the index A column and place formulas on sheet supplied.<br>Many thanks<br>Ian
</div>


<div>
Not sure if Index is the right term but each range has a separate colored cell<br>to highlight the range.
</div>


retired

Ian Bell

<div>
Here is an example with A col at end of formula<br>MIN(IF($EM$14:$EM$60000=EM14,$A$14:$A$60000)))<br><br>
</div>


<div>
Sorry, doesn't help, but I think I have worked out what you mean.<br><br>Column A has 10 in rows 2 to 6 so need to count F2 to U6 for 1 and 1 to 3<br>Column A has 20 in rows 7 to 10 so need to count F7 to U10 for 1 and 1 to 3<br>Column A has 30 in rows 11 to 14 so need to count F11 to U14 for 1 and 1 to 3<br><br>No doubt the number of rows per index will change so you want it dynamic.
</div>


<div>
My apologies Rob for the confusion and also the delay in replying. Just returned from a shopping trip :)<br>I made a mistake with that index reference. Your formula is perfect <br>Thanks again for your help;<br>&nbsp;
</div>


<div>
No worries, thanks for the feedback.
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>Hi</p><p>I would like to count number of specific values.</p><p>I have attached a sheet with explanation and sample data.</p><p>Many thanks</p><p>Ian<a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2021/11_w47/1578051/Count-specific-values.xlsx" rel="ugc">Count specific values.xlsx</a>&nbsp;</p>
</div>
</div>


Count-specific-values.xlsx


Hi
I would like to count number of specific values.
I have attached a sheet with explanation and sample data.
Many thanks
Ian
Count specific values.xlsx
 

Count Specific values in an indexed range.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.