Hi

If you use , between the arrays, you need -- also before the two first
arrays, to convert TRUE/FALSE to 1/0, or you can use * between the arrays:

=SUMPRODUCT(--(Detail!$A2:$A12440 ="^C"),--(Detail!$M2:$M12440
=""),Detail!L2:L12440)

=SUMPRODUCT((Detail!$A2:$A12440 ="^C")*(Detail!$M2:$M12440
="")*Detail!L2:L12440)

Also I am not sure if you should put ^ in front of 'C'

Hopes this helps.
....
Per

"Rbirdie" skrev i meddelelsen
...
I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a
column.
I am trying to get a total of each region with notes and without notes.


Col A is region
Col M are notes on accts
Col L are dollars

A M L

1. C Notes in field 3.15
2. W Blank 100.50
3. NE Notes in field 600.00

Here is my formula:
=SUMPRODUCT((Detail!$A2:$A12440 ="^C"),(Detail!$M2:$M12440
=""),(Detail!L2:L12440))

It is returning 0. If I play with the formula and change the , to -- then
it
does return a value, but one that is not correct.
I also tried filling in the BLANKS of column M with a word and that did
not
help.
Please any help is appreciated.