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
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY by Debra Dalgleish
There's an example here that counts visible cells in a filtered column. You could modify the SUMPRODUCT formula to reference your cells, and add one more...
January 11th, 2005 01:58 PM
by Lisa Go to last post
3 146
templates by Terri
I would like to create my own worksheet to save as a template for accountancy book keeping for small business. I have searched for suitable templates...
January 11th, 2005 02:23 PM
by Terri Go to last post
0 82
Question
Help! + and - and blank cells by Helen Black
I am trying to do a worksheet for our drivers hours, I have totalled up their hours and deducted 48 hours max working week, I have then deducted 48 hours off...
January 11th, 2005 03:38 PM
by Helen Black Go to last post
0 91
conditional formatting conflict? by Abi
I have a three column sheet. The first column pulls information from another sheet. The the other two are going to be blank with underline where someone will...
January 11th, 2005 04:41 PM
by Abi Go to last post
2 409
Using a grouping of cells to check one cell against another... by deucer
Hello, There is a group of 56 cells that contain 3 letter groups (i.e. DCM, DCP, DCE, NTP). There is a column of cells that are listed in the following...
January 11th, 2005 05:19 PM
by JulieD Go to last post
1 208
table by dow
I need help making a table in Excel 2000. I want to make a table in a worksheet (sheet 2) that incorporates numbers (calculation 1 & caculation 2) that are...
January 11th, 2005 06:17 PM
by dow Go to last post
0 119
Dates by aeroman55
How can I return a date, six months plus the first of the following month from a specified date? In other words, both January 1, 2005 and January 31, 2005...
January 11th, 2005 07:26 PM
by Jason Morin Go to last post
2 105
Drop Down List by Sandy
ello Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create a drop down for C3 that includes the same drop down from book1 but not...
January 11th, 2005 11:50 PM
by Max Go to last post
3 336
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function by Oscar
I am trying to use a SUMIF funtion in which the "sum_range" is defined as a named range of cells. If I include the range name in the formula everything is...
January 12th, 2005 12:01 AM
by Bob Phillips Go to last post
2 315
Cell lock help by S.C
Is there a way to lock a specific set of cells and not the whole work sheet? I have several cells that have formulas in them that I do not want changed, but...
January 12th, 2005 12:01 AM
by Gord Dibben Go to last post
2 90
Lookup by tjh
Hello, Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function...
January 12th, 2005 03:14 AM
by Peo Sjoblom Go to last post
3 72
Updating links by Brian
Help! I have placed a two workbooks on a server one workbook relies on the other for data. I have changed the sources after placing them on the server and...
January 12th, 2005 04:05 AM
by Dave Peterson Go to last post
1 85
refresh pivot tables through a macro by dolph
Hi all, I'm trying to create a macro to update pivot tables with a macro. but when I create it and then try to run it, I receive the message: It' impossible...
January 12th, 2005 04:16 AM
by Dave Peterson Go to last post
1 241
countif a date is greater than today by Keith
Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith
January 12th, 2005 04:37 AM
by Keith Go to last post
3 95
Sumif, 2 criteria by Steve
I have seen about a dozen entries with that subject. I can't get a single of oneof them to work. Am I missing something? In the range n12:n1000 I am looking...
January 12th, 2005 05:05 AM
by Sir Paul Go to last post
5 105
How to make empty cells as zero in excel add-ins for SQL Server an by Microlong
I met a problem when I want to create chart by Excel add-ins for SQL SERVER Analysis. after I extracted data from some cube, I find some cells are empty. It...
January 12th, 2005 07:31 AM
by Microlong Go to last post
0 350
How do I give all access to one worksheet but not to other worksh. by B Fraissinet
I'm using Excel 2003, The 1st worksheet is our project staff schedule the other 8 are individual's timesheet that feed from the 1st worksheet. I don't want...
January 12th, 2005 07:37 AM
by Arvi Laanemets Go to last post
1 197
Include several choices in an IF statement. by kevin
Once again thanks for your help folks. Could someone show me how to write the following if statement. =IF(A1=RED OR BLUE OR GREEN OR BLACK OR ORANGE,1,0) I...
January 12th, 2005 12:45 PM
by kevin Go to last post
6 95
Conditional formatting refering to another cells' value by gizmo
Hi guys, I wonder if it's possible to format conditionally a cell according to the value in another cell. F. ex., we format cell A1 like this: If value in...
January 12th, 2005 02:06 PM
by RagDyeR Go to last post
1 147
Calculation within IF function by Andrew
I searched b-boards for previous comments, but I didn't see any. The calculator on my desk says that 5625*0.07 =...
January 12th, 2005 02:37 PM
by Andrew Go to last post
2 96
Post New Thread


Display Options
Showing threads 9901 to 9920 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 06:50 PM.


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