Count Formula Help

[DanielBellfield]

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.

Please see below example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]SOD[/TD]
[TD]SHD[/TD]
[TD]HSD[/TD]
[TD]PART[/TD]
[TD]ORDER NO[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]123[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]65189[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]456[/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]789[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]59723[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]123[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]456[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Jonmo1]

Try

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

 

[DanielBellfield]

Hi Jonmo1,

Thanks its worked a treat!

Dan

 

[Jonmo1]

You're welcome.