Calculating Awarded Estimates
![Rgioff](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we have been awarded to the total number we have quoted to date.
I would also like then to check how many awarded projects have been repeat job as opposed to new jobs. There is a column checked if the estimate is a repeat job.
Comments
-
I think this is what you are looking for for your first request.
=AVG(COUNTIF(Awarded:Awarded, =1) / (COUNTIF(Status:Status, ="Quoted")))
-
This will give you the count of all Awarded and Previously Quoted jobs.
=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?]1)
-
Put on the brakes. There was an error there.
=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?],1)
Help Article Resources
Categories
Check out the Formula Handbook template!