formula help

M

Manos

Dear all,


i have a table where in column b i have prices of a product
eg. B9=5, B10=5.75, B11=6 ETC

In column C i have dates, where starting form C9
From area D10 to AA650 i have numbers (1 or 2 or 3 or
nothing)
From D9 to AA9 i have also dates

There is anyway to search the area form D10 to AA10 to see
if there is a number and if there is to calculate the
following
(e9-c9)*b9 + (j9-c9)*b9 + ...

For example if there is no any figures form d9 to AA9
there would be no number
It is difficult to select the range and tell the function
to take only the areas that have the numbers and work on
it...

Any ideas?

Thanks in advance manos.

PS. I can send you a table by attachment
 
Top