# Formula for calculating a percentage of a range of information

#### woodm71

##### New Member
I am trying to put together a formula that will calculate a percentage of contracts that our company bid against what we receive.

We would also use this to calculate contracts won against bid.

The problem is that the list of contracts will increase as we tender works and therefore the formula needs to be able to take blanks cells into account.

 Tender Bid % Formula needed here Tenders Won % Formula needed here TXM ITT Ref. Year Title Client Partner Client ITT Ref. (If available) Date Recieved Bid / No Bid PCL-ITT-001 2014 Tender 1 ABC Structures Bid PCL-ITT-002 2014 Tender 2 DEF N/A Bid PCL-ITT-003 2014 Tender 3 GHY N/A Bid PCL-ITT-004 2014 Tender 4 LEF SML Bid PCL-ITT-005 2014 Tender 5 BBR N/A No Bid PCL-ITT-006 2014 Tender 6 VRE N/A No Bid PCL-ITT-007 2014 Tender 7 BFK N/A Bid PCL-ITT-008 2014 Tender 8 TRR Structures 30 September 2014 Bid PCL-ITT-009
<colgroup><col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3225;"> <col width="50" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1689;"> <col width="170" style="width: 127pt; mso-width-source: userset; mso-width-alt: 5785;"> <col width="149" style="width: 111pt; mso-width-source: userset; mso-width-alt: 5068;"> <col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5017;" span="2"> <col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5017;" span="2"> <tbody> </tbody>

Thanks,

Mark

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### Andrew Poulsom

##### MrExcel MVP
Welcome to MrExcel.

Replies
1
Views
172
Replies
4
Views
305
Replies
13
Views
749
Replies
2
Views
260
Replies
5
Views
399

1,109,367
Messages
5,528,271
Members
409,813
Latest member
robyrux

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...