# formula help

#### kboy22vitt

##### New Member
Hi, I'm new to formulas and new to the site. I have been using some video training in hope of getting the info I require. But at the moment I'm struggling to find any videos that actually are in line with what I am trying to do. Please bare with me as I'm a beginner. I have managed to write a formula on my sheet that counts the number of dates in a column. I have also counted the number of TBC values in another. How do I go about counting the number of Date values in first column that contain TBC in the other column? In hope of explaining this better the dates are for entries that have a scheduled date, but I want to find the amount of those that are scheduled, but don't have something confirmed in place for (TBC in the other column). For instance the below would result in 1
 Actual Date Schedule Date 10-Mar-13 24-Mar-13 18-Mar-13 24-Mar-13 18-Mar-13 24-Mar-13 TBC 24-Mar-13 18-Mar-13 24-Mar-13

<colgroup><col width="187" style="width: 140pt; mso-width-source: userset; mso-width-alt: 6838;"> <col width="183" style="width: 137pt; mso-width-source: userset; mso-width-alt: 6692;"> <tbody>
</tbody>

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Andrew Poulsom

##### MrExcel MVP
Welcome to MrExcel.

One way:

=SUMPRODUCT(--(A2:A6="TBC"),--(ISNUMBER(B2:B6)))

##### MrExcel MVP
Hi, I'm new to formulas and new to the site. I have been using some video training in hope of getting the info I require. But at the moment I'm struggling to find any videos that actually are in line with what I am trying to do. Please bare with me as I'm a beginner. I have managed to write a formula on my sheet that counts the number of dates in a column. I have also counted the number of TBC values in another. How do I go about counting the number of Date values in first column that contain TBC in the other column? In hope of explaining this better the dates are for entries that have a scheduled date, but I want to find the amount of those that are scheduled, but don't have something confirmed in place for (TBC in the other column). For instance the below would result in 1
 Actual Date Schedule Date 10-Mar-13 24-Mar-13 18-Mar-13 24-Mar-13 18-Mar-13 24-Mar-13 TBC 24-Mar-13 18-Mar-13 24-Mar-13

<tbody>
</tbody>

Try one of:

=COUNTIFS(B2:B6,"<>",A2:A6,"TBC")

=SUMPRODUCT(--ISNUMBER(B2:B6),--(A2:A6="TBC")

Or control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(B2:B6),(A2:A6="TBC")+0))

Replies
1
Views
63
Replies
3
Views
187
Replies
3
Views
294
Replies
1
Views
184
Replies
3
Views
123

1,195,670
Messages
6,011,074
Members
441,581
Latest member
rp4717

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back