Hi Megs,
What is the address of the formula, and what is the formula, and
what direction are you trying to drag the formula, and what formula
do you want to see in the second cell..

I am assuming this is strictly a SUMIF formula.

for instance
C3: =sumif(A1:A3,100) .
perhaps should have been started at
A1: =SUMIF($A$1:$A3, 100)
in order to fill down.

Fill Handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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.