Fixed that already, still getting the formula error


"JE McGimpsey" wrote in message
...
Change $C$1000 to $C$10000

all arrays must be the same size.

In article ,
"syrac" wrote:

Hi Bob,

I tried your formula and it is giving me an error (that was the message
two)



"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(Sheet1!$A$2:$A$10000 = $A6),--(Sheet1!$D$2:$D$10000 =
"EMAIL"),--(TEXT(Sheet1$C$2:$C$1000,"mmm")="Jun"))