COUNT IF meeting certain crieteria

[Rino468]

hi all - Thanks ahead of time if you can help me !

I am trying to create the formula to count cells if there are values but it has to meet certain criteria. I need to count how many laps a car makes a lap around the track. The only data points I have are the laps and the speed in which each car was going around them. Towards the bottom is kind of how I want it to look


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Speed Lap 1[/TD]
[TD]Speeed Lap 2[/TD]
[TD]Speed lap 3[/TD]
[TD]Speed Lap 4[/TD]
[/TR]
[TR]
[TD]Car A[/TD]
[TD]45[/TD]
[TD]104[/TD]
[TD]67[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Car B[/TD]
[TD]75[/TD]
[TD]103[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car C[/TD]
[TD]105[/TD]
[TD]89[/TD]
[TD]77[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total Laps[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car A[/TD]
[TD]What Formula to use?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car B [/TD]
[TD]What Formula to use?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car C[/TD]
[TD]What Formula to use?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

****** id="cke_pastebin" style="position: absolute; top: 120px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Speeed Lap 2[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[AhoyNC]

Try:
Change range to match your data and copy down.

Excel Workbook
	A	B	C	D	E
1		Speed Lap 1	Speeed Lap 2	Speed lap 3	Speed Lap 4
2	Car A	45	104	67	100
3	Car B	75	103
4	Car C	105	89	77
5
6
7	Car A	4
8	Car B	2
9	Car C	3
Sheet

 

[Rino468]

thank you !