Thanks!!!!!

Much clearer now :-)


"JulieD" wrote in message
...
Hi Danny

i understand the SUMPRODUCT function this way - each element (ie
a1:A10="ford") of the function is evaluated to either true (1) or false
(0)
FIRST, these results are multiplied together to give a combined true /
false
result of the full statement and then the results of this are added
together
to give the count of records meeting both criteria.

so taking the "Ford / June" example
(a1:a10="Ford")
A1=0;A2=1;A3=1;A4=1;A5=1;A6=0;A7=0;A8=0;A9=0;A10=0
so you end up with 0;1;1;1;1;0;0;0;0;0

then take (b1:b10="June")
B1=0;B2=1;B3=1;B4=0;B5=1;B6=1;B7=1;B8=1;B9=0;B10=1
so you end up with 0;1;1;0;1;1;1;1;0;1

now multiply these together to get a combined true / false on the full
statement
0*0;1*1;1*1;1*0;1*1;0*1;0*1;0*1;0*0;0*1
which equals
0;1;1;0;1;0;0;0;0;0
now add these together as we're counting how many meet both criteria and
you
get your answer of 3.

Hope this helps
Cheers
JulieD





"Danny J" wrote in message
...
Hi Frank,

Thanks for your help. The formula works but I am unclear on the non
classical use of Sumproduct. Looking at the web page you cite an
example
to
count the number of Ford cars sold in June
=sumproduct((a1:a10="ford")*(b1:b10="June")). However there are 4
instances
of the word Ford in column A and 7 instances of June in column C so why
does
return a value of 3 (which is correct for the number of Fords sold in
June)
rather than 4*7=28?

Sorry if I am being stupid.

Thanks,

Danny