LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim
 
Posts: n/a
Default copy and paste formulas

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, how do you copy and paste just the subtotals into anoth. mmiazga Excel Discussion (Misc queries) 4 February 13th 05 01:17 AM
sending data from one cell to another (not using copy & paste) Charlie Payne Excel Worksheet Functions 3 December 6th 04 03:28 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM
Copy and Paste Steve Excel Discussion (Misc queries) 2 December 2nd 04 12:35 AM
copy and paste G Excel Worksheet Functions 2 November 2nd 04 01:56 AM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"