Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CM CM is offline
external usenet poster
 
Posts: 136
Default How to subtract with 3D between 3 worksheets

referece the cells in sheets 1 and 2 like this:

=Sheet1!E22

"Tabis" wrote:

I have 3 worksheets. First one with budgeted sales, second with actual sales
and I need to use a 3D reference to get the variance on sheet three.

Reply
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
How do i subtract 3 hrs from now()? Andy Excel Worksheet Functions 9 April 29th 23 11:44 AM
How can I subtract cells in two different worksheets? Carl M Excel Discussion (Misc queries) 3 April 3rd 23 04:34 PM
Subtract Chi Excel Worksheet Functions 0 April 1st 08 02:52 PM
how do i add and subtract kim New Users to Excel 4 December 22nd 07 12:10 AM
how to subtract one row from the other? prasad Excel Discussion (Misc queries) 1 April 8th 05 08:38 PM


All times are GMT +1. The time now is 06:36 AM.

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

About Us

"It's about Microsoft Excel"