Guys,
Thanks to all for your help. Problem now solved and working a
treat. :-)
ArtySin
On Sep 15, 5:09 pm, ArtySin wrote:
> Hi
> I have two columns as below using Excel 2000 (unfortunately, corporate
> no spend policy): These columns have been exported from a database and
> a
count up the total of passed or failed for the 22/08/2011
would give a result of 4
I've tried =SUMPRODUCT(--($A$2:$A$11=A2)--($A$2:$A$11=A3)*--($B$2:$B
$11=B2)) and various countifs with AND statements but I can't get
this to work.
Many than
