It is probably because you don't have your absolute and relative references
correct. Generally, if sat using SUMIF, it should be of the form

=SUMIF($A$2:$A$100,M1,$B$2:$B$100)

that is the condition range and the sum range should be absolute, the value
to test for should be relative.

--
HTH

Bob Phillips

"Megs" wrote in message
...
Is it possible to copy the conditional sum add-in formula over to
additional
cells? If so, how? I have never been able to get the formula to drag and
copy.