Hi everyone,
I am a bit stuck.
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Sales Br[/TD]
[TD]Del date[/TD]
[TD]New Used[/TD]
[TD]Postcode[/TD]
[TD]Sale Type[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]02/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]02/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]03/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]04/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]
I want to count up the number of times a product is bought at Sales Br 1 and is "N" and has Sale Type "R" IF the Del Date ='Input Sheet'!C3
So to Psudeo code it
If Del Date = 'Input Sheet'!C3 AND Sales Br = 1 AND Sales Type ="R" THEN count the number of times this occurs.
Does this make sense? It is just not clicking with me and I have tried
Any help you can give me would be appreciated guys
Thanks in advance
Jay
I am a bit stuck.
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Sales Br[/TD]
[TD]Del date[/TD]
[TD]New Used[/TD]
[TD]Postcode[/TD]
[TD]Sale Type[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]02/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]02/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]03/05/2014[/TD]
[TD]U[/TD]
[TD]XX16 5XX[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]04/05/2014[/TD]
[TD]N[/TD]
[TD]XX16 5XX[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]
I want to count up the number of times a product is bought at Sales Br 1 and is "N" and has Sale Type "R" IF the Del Date ='Input Sheet'!C3
So to Psudeo code it
If Del Date = 'Input Sheet'!C3 AND Sales Br = 1 AND Sales Type ="R" THEN count the number of times this occurs.
Does this make sense? It is just not clicking with me and I have tried
Any help you can give me would be appreciated guys
Thanks in advance
Jay