A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
ytd sum by selecting month by Greg
I have rows of data with a date column (example: 31-May-05), starting Jan through May. Is there a way to sum column 'A' ytd based on the month I select? ...
June 20th, 2005 10:17 PM
by Dave Breitenbach Go to last post
1 79
YTD formula help by pswift
hi, I am looking to try to use a value on another sheet into a formula to calculate my YTD numbers instead of having to go through the entire YTD data to get...
February 6th, 2006 07:58 PM
by just_jon Go to last post
1 73
Ytd formula by Michel
I have a database in a workbook which is increasing on a daily basis. the column consiste of e.g Date country T.operators Rm Type Qty Amount etc I have a...
May 19th, 2010 07:39 PM
by Michel Go to last post
0 174
YTD Calculation using SUM and OFFSET by dallen917
I have some financial data with months (Jan - Dec) across the top and cost categories (such as Labor, Materials, Travel) down the side. This data...
April 29th, 2009 04:52 AM
by T. Valko Go to last post
4 168
YTD calculation using same cell by Molly
I am creating a pipeline that has new data entered each week. I want the weekly figure to automatically add on to the monthly figure. Eg. A ...
April 21st, 2007 02:14 PM
by JE McGimpsey Go to last post
3 62
YTD Budget Totals by Dewayne
Hi - I need to get budgeted year-to-date totals for a budget worksheet. Range E7:P7 has actuals for the months (Jan-Mar) YTD. Range E8:P8 has the...
April 5th, 2005 05:30 AM
by Biff Go to last post
3 93
YTD Budget Sum if Actual Month has activities by AGnes
My worksheet has 50 rows showing sales for each book. It has 39 columns - 3 for each month - budget, actual and diff - and 3 more columns for YTD. They are...
March 24th, 2005 10:25 PM
by Gary Brown Go to last post
1 310
YTD budget formula based on current actual input by Sanj
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 ...
June 10th, 2009 06:04 PM
by Ashish Mathur[_2_] Go to last post
4 142
YTD Average Formula to continue on new worksheet by Arayne
I have split up my worksheet so the first 6 mos is on one sheet and the last 6 months is on a second sheet. I need to bring over my YTD Average and...
August 22nd, 2008 04:03 PM
by Joe L Go to last post
2 108
YTD average cust calulation by zy1972
Hi, I have the following schedule. Basicall, I would like to drive my YTD average customer calculation by input month. Is there a simple formula to achieve...
July 4th, 2008 06:41 PM
by NoodNutt Go to last post
3 75
YTD average - How do I create a formula? by Dana
A column of monthly totals Jan 400 Feb 800 Mar 0 Apr 0 May 0 Need a simple formula that will return an average on non zero months ie: 600
February 1st, 2006 07:48 AM
by [email protected] Go to last post
2 93
YTD % over 12 accumulating figures by Ellie
I have a spreadsheet listing out employees, e.g. as follows: Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD% A N Other ...
May 27th, 2010 11:03 PM
by Jacob Skaria Go to last post
1 258
Your online office "help" system REALLY sucks!! I'm not kidding!! by ViceGodGiarc
Finding stuff is rather frustrating... online is "slow"... whatever happened to the option of standard help files on a local drive? The whole help interface is...
September 13th, 2005 03:25 AM
by Mike Middleton Go to last post
1 172
Your help please in updating a column using Count or an Array Formula by [email protected]
I am using Windows Vista Ultimate OS, Microsoft Office Ultimate-Excel 2007. Problem is updating, Sheet four (4) the tally sheet, the column total number of...
February 12th, 2008 05:31 PM
by [email protected] Go to last post
3 63
You've entered too many arguments for this function by Guillaume Hanique
Hello, First of all: happy new year! I have a sheet that displays data of different weeks for a period. See below. A B C D ...
January 5th, 2004 05:45 PM
by Leo Heuser Go to last post
3 305
You should design a way of doing algebra calculus on a computer by Adrian
Seems to me that there is no easy way of entering calculus style equations into Excel and I just think it would be such a cool tool for students and pure...
October 16th, 2005 09:37 PM
by Adrian Go to last post
0 129
You should be able to lock individual Excel cells by Jen
You should be able to lock individual cells on a worksheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions...
May 6th, 2006 07:38 PM
by Don Guillett Go to last post
3 83
You Need Fast Money ????? by You Need Fast Money???
You Need Fast Money ?????, visit http://dinero4ever.blogspot.com Now!!!
December 17th, 2008 12:37 AM
by You Need Fast Money??? Go to last post
0 144
You guys are on the ball in here ... by Spike9458
Hi All, I don't know where to post this, and I've gotten lots of help here before. What I need is to be able to setup a macro that will launch from...
February 15th, 2006 08:24 PM
by Spike9458 Go to last post
4 63
you are help me by [email protected]
you are help me please my web site open and see the ads %%%%%%%%%%%%%%%%%%%% http://padmagirl.blogspot.com %%%%%%%%%%%%%%%%%%%%% thank you god bless you with...
January 17th, 2008 06:15 AM
by [email protected] Go to last post
0 49
Post New Thread


Display Options
Showing threads 141 to 160 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:27 AM.


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