| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count function
Is there a way to enter a formula that counts the number of cells that start
with "MC" within a certain range? I.E. - Count the cells from U9:U278 that start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not work. Any help? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count function
=COUNTIF(U238:U240,"MC*")
-- Regards, Peo Sjoblom "lightbulb" wrote in message ... Is there a way to enter a formula that counts the number of cells that start with "MC" within a certain range? I.E. - Count the cells from U9:U278 that start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not work. Any help? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count function
Try
=SUMPRODUCT(--(LEFT(U238:U240,2)="MC")) Mike "lightbulb" wrote: Is there a way to enter a formula that counts the number of cells that start with "MC" within a certain range? I.E. - Count the cells from U9:U278 that start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not work. Any help? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Function | Excel Worksheet Functions | |||
| WHICH COUNT FUNCTION? | Excel Worksheet Functions | |||
| COUNT Function | Excel Worksheet Functions | |||
| count function | Excel Worksheet Functions | |||
| Sum and Count Function | Excel Worksheet Functions | |||
Linear Mode
