Hi, i have a question about varying costs. If say i'm ordering 50 items, and
i want to find out the total cost for these 50 items, but, they have varying
costs for different numbers for instance, the first 10 costs 10$, the second
15 costs 15$, etc. Is there a simplay way of telling excel to do this for me
if i just enter the number of items into a column, and have a table off to
the side with the varying prices and the conditions? Thank you so much!

Maybe the DSUM database function.
See the help example for DSUM; if you can sum by the height of the apple trees,
you can probably use your criteria to sum.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Alisha"
wrote in message
Hi, i have a question about varying costs. If say i'm ordering 50 items, and
i want to find out the total cost for these 50 items, but, they have varying
costs for different numbers for instance, the first 10 costs 10$, the second
15 costs 15$, etc. Is there a simplay way of telling excel to do this for me
if i just enter the number of items into a column, and have a table off to
the side with the varying prices and the conditions? Thank you so much!

Thanks Jim, i just had a huge table that i needed to fill out, and couldn't
use the database functions since each entry requires the criteria to have
matching headings and all that...so, i just did a pretty long if statement
for it :-p oh well. Thanks again though!

"Jim Cone" wrote:

Maybe the DSUM database function.
See the help example for DSUM; if you can sum by the height of the apple trees,
you can probably use your criteria to sum.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Alisha"
wrote in message
Hi, i have a question about varying costs. If say i'm ordering 50 items, and
i want to find out the total cost for these 50 items, but, they have varying
costs for different numbers for instance, the first 10 costs 10$, the second
15 costs 15$, etc. Is there a simplay way of telling excel to do this for me
if i just enter the number of items into a column, and have a table off to
the side with the varying prices and the conditions? Thank you so much!