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