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 / Thread Starter Last Post Replies Views Reverse Sort Order
Sum based on specific condition by Wendy
Need help...I am trying to sum only those values in column (D) whose corresponding value in column (A) is greater than the value in column (B). (A) ...
(Multi-page thread 1 2 3 ... Last Page)
June 7th, 2007 09:25 PM
by Harlan Grove[_2_] Go to last post
43 1,635
Calculating age from birth dates by John Nall
I need help with a similar problem. I am making a spreadsheet with the names, DOB, and DOD dates for persons in a church cemetery. I am having trouble with...
September 15th, 2003 04:39 AM
by Myrna Larson Go to last post
2 1,624
Counting question by John
In column A I have set of characters that are entered into the rows below (i.e. Y, N, MRO) in column B I have another set of characters that are entered into...
(Multi-page thread 1 2)
June 4th, 2010 05:46 PM
by Ms-Exl-Learner Go to last post
16 1,619
Excel Formula Help please by Seventh Day is The Sabbath
Please Help, I am trying to make a formula which you may think is simple, but my old head finds it hard, I am trying in excel to change a corresponding time in...
May 22nd, 2004 10:54 AM
by Seventh Day is The Sabbath Go to last post
3 1,596
How to omit blank cells when calculating weighted averages by Suzy
Hello, new to Excel and need help with function. I am calculating grades for my students, and if they were absent, I do not want them penalized. What function...
(Multi-page thread 1 2 3)
March 18th, 2010 11:00 PM
by T. Valko Go to last post
20 1,596
Don't show Zeros by Morpheseus
I know I've seen this somewhere but I cannot find it. I looked all day with no luck. I have to ask what I know is a simple question :( I did up an invoice. ...
September 15th, 2003 09:42 AM
by Andy Brown Go to last post
2 1,595
Excel 2003: RAND and RANDBETWEEN functions by Rita Nikas [MSFT]
Hi all. I just wanted to give you some information on this concern direct from Microsoft. In addition, this problem was mentioned in Woody's Watch, and...
(Multi-page thread 1 2 3)
February 14th, 2004 02:37 AM
by Norman Harker Go to last post
20 1,578
Excel formula - select cells based upon fill color and then sum by
-----Original Message----- I want to sum data baed upon the fill color. An existing spreadsheet has been manually shaded to show the "selected cells". ...
May 13th, 2004 07:45 PM
by Go to last post
0 1,576
Arrary formula for Average includes blank cells by jan
I am using an Average formula (array) on a summary worksheet to return the average of a set a data from another worksheet (detail) based on location. The...
May 14th, 2004 11:19 PM
by Frank Kabel Go to last post
4 1,571
Drop Down Lists 2007 by tlynn
I have followed all the steps in creating a drop down list in Excel 2007: Created Named list on seperate sheet goto the sheet that the drop down will be on...
(Multi-page thread 1 2)
June 2nd, 2010 01:19 PM
by Max Go to last post
10 1,554
Help using the LARGE function "WITHOUT" using an array by exceluser
Can someone show me how to accomplish the following by using the LARGE function "WITHOUT" using an array ? I'm trying to rank each product (most, second most,...
June 5th, 2010 11:17 PM
by exceluser Go to last post
6 1,549
IF STATEMENT by sbain
I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01) First off, the statement does not seem to evaluate the "roundup" part, meaning that...
(Multi-page thread 1 2)
June 3rd, 2010 10:35 AM
by Steve Dunn Go to last post
19 1,546
Merging Columns by Titanium
I am trying to 'make one' a number of columns... Essentially I have several thousand rows of data that I need to clean up... What I would like to accomplish is...
(Multi-page thread 1 2)
May 31st, 2010 09:36 PM
by vhnbvb Go to last post
13 1,546
EXCEL 2002 INVOICE TEMPLATE by BRIAN
IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...
December 28th, 2003 05:02 AM
by Gord Dibben Go to last post
2 1,540
Question
Formula checking multiple worksheets by sonic-the-mouse
I have been tasked with streamlining a spreadsheet used at work. It previously had 28 worksheets A sheet for each month of the year to list occurences An audit...
(Multi-page thread 1 2)
June 6th, 2005 06:37 PM
by Biff Go to last post
11 1,522
Calculating a rolling calendar year by Dana
I am trying to keep track of employee attendance (small company - under 50 people) in Excel. I have created a workbook that has a sheet for each employee. In...
March 4th, 2004 11:25 PM
by Go to last post
2 1,509
xdate in Windows 7 by Help with scheduling issue
I finally entered the world of Windows 7, albeit only because my laptop died. I am a historan who needs to calculate dates into the 18th century. Xdate...
June 6th, 2010 11:01 AM
by Hans Terkelsen Go to last post
2 1,490
Excel formula - select cells based upon fill color and then sum by Peo Sjoblom
There are no built in functions but there are other ways http://www.cpearson.com/excel/colors.htm -- Regards, Peo Sjoblom
May 13th, 2004 06:52 PM
by Frank Kabel Go to last post
1 1,484
copying a formula down wards by UKMAN
=INDEX(Proj_code,MATCH(AQ$6,F$7:F$198,0)) the above formula works in that it shows the first match. As there could be mulitpule records what do I need to do...
(Multi-page thread 1 2)
April 26th, 2010 03:41 PM
by Ashish Mathur[_2_] Go to last post
10 1,473
Continuous day countdown excluding weekends and public holidays (urgent) by drewmacher
Hello. Does anyone know how to use a statement or a function that calculates how many days are remaining from a start date to a due date, but excluding...
March 16th, 2004 07:33 AM
by Frank Kabel Go to last post
3 1,457
Post New Thread


Display Options
Showing threads 61 to 80 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 09:35 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.