| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i count specific text strings excluding blank cells?
I am trying to build a spread sheet than counts specified text strings from
numerous sheets. There will not be the same number of cells on each sheet with a value. I need to be able to count certain values while excluding the blank cells. can anyone out there help? Thanks, Justin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count specific text strings excluding blank cells?
=SUMPRODUCT(--(ISNUMBER(SEARCH("Jon",OFFSET(Sheet1!A1,0,0,COUNTA (Sheet1!$A:$A),COUNTA(Sheet1!1:1))))))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "skijsh1979" wrote in message ... I am trying to build a spread sheet than counts specified text strings from numerous sheets. There will not be the same number of cells on each sheet with a value. I need to be able to count certain values while excluding the blank cells. can anyone out there help? Thanks, Justin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count specific text strings excluding blank cells?
I am trying to use this formula, but it says that the zero after the BNSF
3167: is incorrect. I am going to have like 30 sheets, with anywhere from 2 to 10 cells that need to be searched and counted for the text string. =SUMPRODUCT(--(ISNUMBER(SEARCH("HV HIGH VOLTAGE",OFFSET('BNSF 2176:BNSF 3167'!,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!1:1) ))))) "Bob Phillips" wrote: =SUMPRODUCT(--(ISNUMBER(SEARCH("Jon",OFFSET(Sheet1!A1,0,0,COUNTA (Sheet1!$A:$A),COUNTA(Sheet1!1:1)))))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "skijsh1979" wrote in message ... I am trying to build a spread sheet than counts specified text strings from numerous sheets. There will not be the same number of cells on each sheet with a value. I need to be able to count certain values while excluding the blank cells. can anyone out there help? Thanks, Justin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Cells That Don't Contain the Following Text Strings | Excel Discussion (Misc queries) | |||
| count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
| count cells that begin with specific text | Excel Worksheet Functions | |||
| If two cells have specific text to count as 1 | Excel Worksheet Functions | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
