| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF criteria
Do it like this:
=COUNTIF(A1:A5,""&B1) The condition is treated as if it were a string, hence the quotes. Hope this helps. Pete On Apr 15, 7:56*pm, bikerhal wrote: How do I use COUNTIF (or SUMIF) where the criteria is of the form X and the value of X is contained in a cell? For example, COUNTIF(A1: A5, B1) does not work in Excel 2003 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Countif two criteria | Excel Discussion (Misc queries) | |||
| More than 1 countif criteria | Excel Discussion (Misc queries) | |||
| COUNTIF with two criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Hybrid Mode
