Jerry,

Thanks for looking at the worksheet. I don't know if you got a chance to
review the formulas; it's very time-consuming.

Regarding your question in your first post, the fee schedule is in columns L
and M. The breakdown is as follows:

0-3 days, $0.25
4-30 days, $1.01
31-60 days, $1.25
60+ days, $1.56

Your suggestion to use the sumproduct function on that last formula was a
good one and I updated the worksheet using that function. The formulas I am
most concerned with are the ones in F7, G7, H7, and I7. I don't know if you
had a chance to review those; this particular worksheet is pretty time
consuming. At any rate, I really appreciate your help!

Thanks,

John

"JBeaucaire" wrote:

Assuming all your other formulas are correct, you can simplify your formula
in J7 to this, then copy down:

=IF(E7="","",SUMPRODUCT($F$6:$I$6*F7:I7))

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"ibvalentine" wrote:

I just created a worksheet that is more complicated than it looks and I want
to make it available for anyone who would do my the favor of looking it over.

The difficulty of the worksheet is that you have to considered all possible
parameters, some of which may not be obvious. So, if you can see any possible
parameters that the formulas may not cover, please let me know. Also, I may
have overlooked some errors.

The objective of the worksheet is to calculate storage fees for April. The
difficult part is that items come in at different times and have different
levels of charges. There is a table in columns L and M that breaks the
charges down.

You can down load the Excel file by going to this page:
http://www.icellini.com/excel.html.

Thanks to anyone that takes a look!