Hi
You do have a problem with your brackets - 1 too many at the end, one toofew
after the end of the first Sumproduct formula.
Unless you have 12* as text in your column, the "12*" won't work. Just plain
=12 will pick up all the occurrences of 12

=SUMPRODUCT(--('Imported Data'!$A$2:$A$30000="12*"),
--(MONTH('Imported Data'!$I$2:$I$30000)=H5),
--(YEAR('Imported Data'!$I$2:$I$30000)=J5))
-SUMPRODUCT(--('Imported Data'!$C$2:$C$30000=6),
--(MONTH('Imported Data'!$I$2:$I$30000)=H5),
--(YEAR('Imported Data'!$I$2:$I$30000)=J5))


--
Regards

Roger Govier


"vipa2000" wrote in message
...
I have he following code. i want to count all the 12's in columnA range
2-30000 on a month picked in cell H5 and a year J5 and then deduct those
records where priority = 6 and month =h5 and year =j5. Just cannot get the
thing to work. i am sure it is the brackets.

=SUMPRODUCT(--('Imported Data'!$A$2:$A$30000="12*"),
--(MONTH('Imported Data'!$I$2:$I$30000)=H5),
--(YEAR('Imported Data'!$I$2:$I$30000)=J5))
-SUMPRODUCT(--('Imported Data'!$C$2:$C$30000=6),
--(MONTH('Imported Data'!$I$2:$I$30000)=H5),
--(YEAR('Imported Data'!$I$2:$I$30000)=J5))

thanks in advance
--
Regards vipa