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 Reverse Sort Order Replies Views
if function help by kathy
i am trying to create an if function that will sum data in a column if the cell value is between certain values. This works for sum if greater than,...
April 29th, 2010 12:58 AM
by Ashish Mathur[_2_] Go to last post
5 80
compound if equation? by Steve
Howdee all. Hope everyone's afternoon, evening, etc... are going well. I have a dual worksheet function that requires something more compound that I've used...
April 28th, 2010 11:43 PM
by Steve Dunn Go to last post
7 151
Average IFS (Multiple Criteria) by FunChickyPoo
I have been using the following SUMIFS funtion that works perfectly, but need to average a column of %. Is ther esucha thing as AVERAGEIFS that will work...
April 28th, 2010 11:35 PM
by PJFry Go to last post
1 107
Average formula where blank cells are counted as zeros by krwelling
I am trying to write an average formula that takes into account the blank cells. I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is...
April 28th, 2010 10:56 PM
by T. Valko Go to last post
4 120
Reverse $String1, String2 to $String2 $String1? by msnyc07
I've done separate functions for specific text e.g. Manager, X = X Manager Supervisor, X = X Supervisor but would love if i could just make a generic Y, X = X...
April 28th, 2010 10:34 PM
by T. Valko Go to last post
1 90
splitting cell content from 1st column into 4 columns by Daphtg
In my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to...
April 28th, 2010 10:30 PM
by Gord Dibben Go to last post
1 92
How do I get warpped data to auto fit in merged cells? by Tom Flaten
I'm developing a survey form. I want to ask a quesiton and the use four merged cells to the right of the question to record the answer. I also want the...
April 28th, 2010 10:20 PM
by Gord Dibben Go to last post
2 105
Average Unique by Nadine
I posted this question with the title of Average If which was a misleading title. I have a column of invoice numbers and multiple rows of data pertaining to...
April 28th, 2010 09:47 PM
by Steve Dunn Go to last post
7 110
Formula Help by Rebecca
I need a formula that will take A1 x B1 but if the number is less then 0 it will only how up as 0 and if its more then 0 if will show up as the real number.
April 28th, 2010 09:15 PM
by Joe User[_2_] Go to last post
3 92
April 28th, 2010 09:15 PM
by TClark Go to last post
0 114
Links not working in Excel 2007 by Carolan
I now have Excel 2007--formerly I used 2003. I have a workbook that is linked to many other workbooks. In 2003, when I opened the workbook it would ask if...
April 28th, 2010 09:08 PM
by Carolan Go to last post
2 177
taking numbers in vertical cells putting them in horizontal cells by jhawk22
I'm looking for the formula that will take numbers in vertical cells putting them in horizontal cells. I'm copying from a worksheet that has numbers listed...
April 28th, 2010 08:37 PM
by jhawk22 Go to last post
4 86
Drop Down Menu by Can''t Cache Me
I have list of people that I am constinly putting into different spreadsheets for various reasons. I want to be able to set up a drop down menu that lists...
April 28th, 2010 07:54 PM
by Luke M[_4_] Go to last post
7 117
Possible to have various sections of worksheets print on 1 page? by Respite Barb
Excel question Because of drastic formatting differences in a document, I've created sections of a document on 3 worksheets. On the first page of the...
April 28th, 2010 07:51 PM
by Luke M[_4_] Go to last post
1 98
Average IFS (Multiple Criteria) by FunChickyPoo
I have used the following formula and it works perfectly, however, one column is % and I want to get an average of the %'s with the same criteria. Can this...
April 28th, 2010 07:15 PM
by T. Valko Go to last post
1 92
Average IFS (Multiple Criteria) by FunChickyPoo
I have used the following formula and it works prefectly, however, one of my columns contains % and I want an average not a sum. Is there a way to use...
April 28th, 2010 07:06 PM
by FunChickyPoo Go to last post
0 85
Pull info from one excel file to another depending on values of O. by Cooldistribution
I need the formula that can transfer rows based on a value of a cell in a row into a different excel file. For example: Part# Jan Mar Oct Total Avg ...
April 28th, 2010 06:21 PM
by Cooldistribution Go to last post
0 103
Can Excel trigger Outlook reminder? by Andee39
I hope I'm asking this question in the right forum. I would like to know if it is possible to create a basic spreadsheet where one of the columns is for due...
April 28th, 2010 05:31 PM
by Andee39 Go to last post
8 127
Calculate Accrued Time by Heather
Good morning! I have searched for this, and couldn't find anything that satisfied what I'm looking for. I'm hoping to find some help with this. I need a...
April 28th, 2010 04:42 PM
by Heather Go to last post
4 84
Default Cell Values at Change by TheDrescher
I keep getting stuck on a workbook I'm finishing up. Basically it displays information on a front sheet that pulls from arrays on other sheets based on a...
April 28th, 2010 04:41 PM
by TheDrescher Go to last post
2 105
Post New Thread


Display Options
Showing threads 921 to 940 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 08:13 PM.


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