| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If statement where the logical test is a range that equals a word
I am trying to figure out how I can return all values in a column using a
term in quotations. Basically, the column is date. I want to return values that fall within a certain month. I am typing in =if(c2:c6421="01/*", sumif(......),0) to get the values that fall within january, it seems right to me but is returning an error. Can you type in a range that is equal to a term in quotations? I don't see why not, but I get an error everytime, even when I run a more simple test. Any suggestions would be greatly appreciated. Thanks! -- Steve Root MCI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I set up as logical test if my range has to be >=2 but <5 | Excel Discussion (Misc queries) | |||
| How do I use Roundup in a logical test in excel | Excel Worksheet Functions | |||
| =IF logical test to search only part of a cell | Excel Worksheet Functions | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
| logical test - within a range | Excel Worksheet Functions | |||
Threaded Mode
