| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help With A Formula That Sums Items In A Column
Column W9 to W60 has different reference codes in different rows.
For example: W9 AO, W10 AX, W11 A1.......W60 AO. How do I sum the number of say, AO's in Column W9 to W60 inclusive? It's a formula I need. Thanks in advance, Gatsby (Not The Great) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help With A Formula That Sums Items In A Column
=COUNTIF(W9:W60,"AO")
Dave -- Brevity is the soul of wit. "Gatsby" wrote: Column W9 to W60 has different reference codes in different rows. For example: W9 AO, W10 AX, W11 A1.......W60 AO. How do I sum the number of say, AO's in Column W9 to W60 inclusive? It's a formula I need. Thanks in advance, Gatsby (Not The Great) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help With A Formula That Sums Items In A Column
Thanks, Dave. Much appreciated.
I was trying to do it with "Sumif". Still balmy in NY? Gatsbt (Not The Great) "Dave F" wrote: =COUNTIF(W9:W60,"AO") Dave -- Brevity is the soul of wit. "Gatsby" wrote: Column W9 to W60 has different reference codes in different rows. For example: W9 AO, W10 AX, W11 A1.......W60 AO. How do I sum the number of say, AO's in Column W9 to W60 inclusive? It's a formula I need. Thanks in advance, Gatsby (Not The Great) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Need a formula that sums a column but could exclude some cells | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
