You need to modify the cell references in your formula - i.e. cell "A3" needs
to be referenced as "$A$3". A formula like that can be copied anywhere
without changing the source cells in the process. Hope that is what you are
looking for.
ChrisJ
"Jim" wrote:
HI,
I currently use this formula:
=SUMPRODUCT(--(AM3:AM10000=TIME(0,0,0)),--(AM3:AM10000<=TIME(0,29,59)),--(AO3:AO10000=1))
How do I paste this into another cell without changing the formula? The
paste special function formulas is changing the destination.
|