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.