| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting a Count
I have two columns, one of which has "2000" among other text while the other
has "No." I need to count the number of times there is "No" in a row if it also contains "2000." From reading previous posts, if appeared that the following would work, but it doesn't. It just brings the calculation to 0. What is the proper of way accomplishing this? Thanks. =SUMPRODUCT((B18:B351="*2000*")*(C18:C351="No")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting a Count
=SUMPRODUCT(--(ISNUMBER(FIND("2000",B18:B351))),--(C18:C351="No"))
"John Deakins" wrote: I have two columns, one of which has "2000" among other text while the other has "No." I need to count the number of times there is "No" in a row if it also contains "2000." From reading previous posts, if appeared that the following would work, but it doesn't. It just brings the calculation to 0. What is the proper of way accomplishing this? Thanks. =SUMPRODUCT((B18:B351="*2000*")*(C18:C351="No")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting a Count
I've got a similar situation.
a b c 1 42 7 2 #N/A 7 3 33 8 4 #N/A 8 5 96 8 I need to count the number of cells where a number appears, but not '#N/A', when column C is 8. So for above, Ans: count =2 Could anyone help ? "Teethless mama" wrote: =SUMPRODUCT(--(ISNUMBER(FIND("2000",B18:B351))),--(C18:C351="No")) "John Deakins" wrote: I have two columns, one of which has "2000" among other text while the other has "No." I need to count the number of times there is "No" in a row if it also contains "2000." From reading previous posts, if appeared that the following would work, but it doesn't. It just brings the calculation to 0. What is the proper of way accomplishing this? Thanks. =SUMPRODUCT((B18:B351="*2000*")*(C18:C351="No")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
