| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if meets criteria add 1
i need a formula that will look at a text/number in a column and go down the
column and add 1 to get a total number of items meeting the criteria. example column D 1, 2P 1P, 2, 3 1, 2 2 1P how do i get it to search for a 1 in the string of text in column D and give me the answer of 4 for the number of times it shows up in that column? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if meets criteria add 1
Hi,
=SUMPRODUCT((LEFT(D1:D10,1)="1")*(1)) Mike "r2rcode" wrote: i need a formula that will look at a text/number in a column and go down the column and add 1 to get a total number of items meeting the criteria. example column D 1, 2P 1P, 2, 3 1, 2 2 1P how do i get it to search for a 1 in the string of text in column D and give me the answer of 4 for the number of times it shows up in that column? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if meets criteria add 1
Try this formula:
=SUMPRODUCT(--ISNUMBER(SEARCH("1",D1:D1000))) "r2rcode" wrote: i need a formula that will look at a text/number in a column and go down the column and add 1 to get a total number of items meeting the criteria. example column D 1, 2P 1P, 2, 3 1, 2 2 1P how do i get it to search for a 1 in the string of text in column D and give me the answer of 4 for the number of times it shows up in that column? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add up a value that meets 2 criteria | Excel Discussion (Misc queries) | |||
| Getting a Value IF a cell meets a criteria | Excel Discussion (Misc queries) | |||
| Do Nothing If Meets Criteria | Excel Discussion (Misc queries) | |||
| SUMIF meets a criteria | Excel Worksheet Functions | |||
| Max value that meets a criteria | Excel Worksheet Functions | |||
Linear Mode
