[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Round[/TD]
[TD]Date[/TD]
[TD]Fixture[/TD]
[TD]Team[/TD]
[TD]Formation[/TD]
[TD]Scored[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9/13/2013[/TD]
[TD]TEAM A v TEAM B[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9/13/2013[/TD]
[TD]TEAM A v TEAM B[/TD]
[TD]TEAM B[/TD]
[TD]4-4-2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/01/2013[/TD]
[TD]TEAM A v TEAM C[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/01/2013[/TD]
[TD]TEAM A v TEAM C[/TD]
[TD]TEAM C[/TD]
[TD]3-5-2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10/08/2013[/TD]
[TD]TEAM D v TEAM A[/TD]
[TD]TEAM D[/TD]
[TD]3-4-3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10/08/2013[/TD]
[TD]TEAM D v TEAM A[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Im having issues using the sumif/countifs functions within this data set. Im convinced the formula ive been using is correct but '0' just keeps appearing. Can anyone think of any reasons why this could be happening and how it can be sorted.
Above is the data set im using.
A4:F10 on my first sheet.
on the second sheet I have the conditions that I would like the data to be sorted.
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]TEAM NAME[/TD]
[/TR]
</tbody>[/TABLE]
Cell L18
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]FORMATION[/TD]
[/TR]
</tbody>[/TABLE]
Cell K24
I would like to Search Column C on the first sheet to see if it contains 'TEAM NAME' Cell on the second sheet. If it does I would then like to Search Column D for a cell that does not contain 'TEAM NAME' Cell.
Then match the formation in Cell K24 counting the cells in row F that match the criteria.
anyhelp with this would be much appreciated i've been struggling on this for a while now.
Thanks
<tbody>[TR]
[TD]Round[/TD]
[TD]Date[/TD]
[TD]Fixture[/TD]
[TD]Team[/TD]
[TD]Formation[/TD]
[TD]Scored[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9/13/2013[/TD]
[TD]TEAM A v TEAM B[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9/13/2013[/TD]
[TD]TEAM A v TEAM B[/TD]
[TD]TEAM B[/TD]
[TD]4-4-2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/01/2013[/TD]
[TD]TEAM A v TEAM C[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/01/2013[/TD]
[TD]TEAM A v TEAM C[/TD]
[TD]TEAM C[/TD]
[TD]3-5-2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10/08/2013[/TD]
[TD]TEAM D v TEAM A[/TD]
[TD]TEAM D[/TD]
[TD]3-4-3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10/08/2013[/TD]
[TD]TEAM D v TEAM A[/TD]
[TD]TEAM A[/TD]
[TD]4-4-2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Im having issues using the sumif/countifs functions within this data set. Im convinced the formula ive been using is correct but '0' just keeps appearing. Can anyone think of any reasons why this could be happening and how it can be sorted.
Above is the data set im using.
A4:F10 on my first sheet.
on the second sheet I have the conditions that I would like the data to be sorted.
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]TEAM NAME[/TD]
[/TR]
</tbody>[/TABLE]
Cell L18
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]FORMATION[/TD]
[/TR]
</tbody>[/TABLE]
Cell K24
I would like to Search Column C on the first sheet to see if it contains 'TEAM NAME' Cell on the second sheet. If it does I would then like to Search Column D for a cell that does not contain 'TEAM NAME' Cell.
Then match the formation in Cell K24 counting the cells in row F that match the criteria.
anyhelp with this would be much appreciated i've been struggling on this for a while now.
Thanks