Calculating Awarded Estimates

Rgioff

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.

Nic Larsen

I think this is what you are looking for for your first request. 

=AVG(COUNTIF(Awarded:Awarded, =1) / (COUNTIF(Status:Status, ="Quoted")))

 

 

Mike Wilday

This will give you the count of all Awarded and Previously Quoted jobs.

=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?]1)

Mike Wilday

Put on the brakes. There was an error there. 

=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?],1)