# Count Formula Help

#### DanielBellfield

##### New Member
Hello one and all,

Help if you will please. I'm trying to run a formula that will count certain cells given that another cell is filled.

 A B C D E F 1 Name SOD SHD HSD PART ORDER NO 2 123 1 65189 3 456 12 4 789 x 59723 5 123 1 6 456 3

<tbody>
</tbody>

I want Excel to Count the number of Cells that are filled Under the "B" Column but only if the "F" Column has data in.

Thanks very much!
Dan

Last edited:

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Jonmo1

##### MrExcel MVP
Try

=COUNTIFS(\$F\$2:\$F\$6,"<>",B\$2:B\$6,"<>")

#### DanielBellfield

##### New Member
Hi Jonmo1,

Thanks its worked a treat!

Dan

#### Jonmo1

##### MrExcel MVP
You're welcome.

Replies
17
Views
505
Replies
12
Views
202
Replies
4
Views
117
Replies
2
Views
229
Replies
11
Views
228

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,777
Messages
5,833,643
Members
430,221
Latest member
jmmccormick

### 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