I guess what my basic question is "Can you make a range (ie, b2:b6000) equal
text?" For example, if(b2:b6000="01/*","good","bad") , making it so that
when it looks through column b any date that pops up would be in january,
then showing the result 'good.' Does b2:b6000 need to be in( )? Whenever I
type in a formula like the one above it gives me an answer of 'bad', when I
know full well there are plenty of january's in the b column.
--
Steve Root
MCI


"Ron Rosenfeld" wrote:

On Fri, 24 Jun 2005 09:35:01 -0700, "Steve o"
wrote:

My goal is to have a formula that will look up a date and multiply the
corresponding infomation. For example, look up any january in the date
column that is Product A and multiply that times the corresponding quantity
(3 different columns (date, product, quantity). I need this formula to be
able to handle the sheet even if data is changed, ie changing the number of
records in the worksheet. So if in the future the data for january grows,
the formula will still be able to locate any products in january that the
formula specifies and then multiply that times the corresponding quantity.
It's a tad bit complicated.
--

How about:

Assum your columns are named date, product and quantity, the product that you
are looking for is in cell A1, and the month you are looking for is in cell A2
represented by the date number (e.g. 2=February)

=SUMPRODUCT((A2=MONTH(Date))*(A1=Product)*Quantity )

Or you could use a pivot table.



--ron