| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF across Multiple Rows and Columns
Hey guys...
What is an easy way to take: COUNTIF(A1:A100,"W") .... And make it look at multiple rows and columns? In other words, I have the following cells that "could" contain a "W", and I simply want to "count" the ones that do: A1, B3, C2, D5, E7 Thanks ahead for any help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF across Multiple Rows and Columns
=COUNTIF(A1:E100,"W")
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) wrote in message ups.com... Hey guys... What is an easy way to take: COUNTIF(A1:A100,"W") ... And make it look at multiple rows and columns? In other words, I have the following cells that "could" contain a "W", and I simply want to "count" the ones that do: A1, B3, C2, D5, E7 Thanks ahead for any help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Transforming Multiple Rows into 2 columns | Excel Worksheet Functions | |||
| Automatically Break Multiple Rows to Two Columns | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Linear Mode
