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:

	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

 

[Jonmo1]

Try

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

 

[DanielBellfield]

Hi Jonmo1,

Thanks its worked a treat!

Dan

 

[Jonmo1]

You're welcome.