Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
copy paste cell character limit | Excel Discussion (Misc queries) | |||
Copy and Paste | Excel Discussion (Misc queries) | |||
copy and paste | Excel Worksheet Functions |