D
Desprateforhelp
I have a database of about 70 records, it looks like this:
Job Material Labor Total Billed Profit %
Name Cost Cost Cost For
Solomon 14,000 12,000 26,000 28,000 2,000 7.1%
I am doing a stats sheet on this database and have made 7
different categories according to the Billed For column
(>50,000;40,000<Billed For<50,000; ect.) I need to be
able to do this: look at the only the profitable jobs
(or unprofitable) in a certain category and get the
average in a certain field (profit, or material cost, or
labor cost). I have tried using DAVERAGE, and it always
returns #VALUE! Need help, thanks
Job Material Labor Total Billed Profit %
Name Cost Cost Cost For
Solomon 14,000 12,000 26,000 28,000 2,000 7.1%
I am doing a stats sheet on this database and have made 7
different categories according to the Billed For column
(>50,000;40,000<Billed For<50,000; ect.) I need to be
able to do this: look at the only the profitable jobs
(or unprofitable) in a certain category and get the
average in a certain field (profit, or material cost, or
labor cost). I have tried using DAVERAGE, and it always
returns #VALUE! Need help, thanks