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
#ref error with Sumproduct by [email protected]
Hello, I'm getting a #ref error with the following formula. I haven't had a problem with this until today. =SUMPRODUCT(('ALL FF...
October 9th, 2006 07:00 PM
by [email protected] Go to last post
5 64
#REF error! by Tom
Excel 2007 SP2+ I'm getting a #REF error on this: =IF(D$1+1=ROW(),SUM(INDIRECT("RawData!F" & ROW()-D$1+1&":RawData!F" & ROW())),"") I've tried several...
September 19th, 2009 07:09 PM
by Tom Go to last post
4 99
#REF errors in links by srinivasan
I have a workbook with links to many worksheets in separate files. Each year I used to change the source files to the corresponding year and the links work...
February 23rd, 2010 06:56 PM
by srinivasan Go to last post
0 90
#ref to equal zero by cherrynich
I need a statement to put in an excel cell that basically says in excel language; If(cell reference=#ref,0,reference). I know for other errors there...
February 6th, 2006 10:31 PM
by cherrynich Go to last post
2 66
#REF using =INDIRECT... by frustratedwthis
I have a workbook with multiple sheets. Each sheet has an original tab name. I am trying to put together a summary of all sheets. In column B (on the summary...
May 31st, 2006 07:28 PM
by frustratedwthis Go to last post
5 87
#REF! by Curtis[_6_]
Why is this giving me #REF! error =INDEX('(312) - POS Pricelist'!$E$5:$E$8148,MATCH('Store Price List'!$A4,'(312) - POS...
March 5th, 2010 07:50 PM
by Luke M[_4_] Go to last post
1 114
#REF! by AMDGUY [MCP]
='I:\Shared\N.C.F\&text(A2-365,"YYYY")\MACH'!$C$40 Gives me #ref! I:\Shared\N.C.F\2004 has previous years CAF-JAN. Every year this changes. Want it to...
February 2nd, 2005 04:29 PM
by Peo Sjoblom Go to last post
8 137
#REF! by Helen
Hello, I have some functions in my spreadsheet that returns "#REF!". That is OK, however I'm wondering if there is a way to format the spreadsheet to...
October 29th, 2005 10:00 AM
by Robert McCurdy Go to last post
3 81
#REF! after cut and paste XL2K by MIke
I have a reference in sheet2 to a list of cells in sheet1. Everytime I paste numbers into the referenced cell of sheet1, sheet2 gives me the #REF! error....
September 24th, 2003 03:07 AM
by Dave Peterson Go to last post
3 87
#REF! Error by Reefaman
Hello I am using this formula to extract data from one worksheet to another: =INDIRECT("Q"&ROW()+168&"!"&"$E$4") The trouble is that when no info is in the...
March 10th, 2006 01:19 PM
by Reefaman Go to last post
3 84
#REF! Error by GiNa
We have a software system on our server that contains our company data. I have created reports using the Table wizard in Excel that accesses this data. The...
June 18th, 2008 10:16 PM
by Spiky Go to last post
5 70
#REF! Error Resolve? by Dan the Man[_2_]
The formula below will produce the #REF! Error in cell L4 until data is input in cells A4 and B4. Once data is input, the #REF! error will go away, and be...
July 30th, 2007 03:28 AM
by Dan the Man[_2_] Go to last post
2 131
#REF! error with Multiple Documents by zxcvbnm6000
I keep receiving a #REF! error when I try to use VLOOKUP to find data in one document and bring it to another. If both documents are open all the numbers are...
February 5th, 2010 03:25 AM
by zxcvbnm6000 Go to last post
7 141
#REF! help by bill gras
I copy and paste a web page into excel in sheet1 The page I import changes every day and is different in size , I delete all data in sheet 1 and copy and...
August 22nd, 2005 11:13 AM
by bill gras Go to last post
5 81
#ref! in calculations off of a getpivot data sum by uvknights
I have a formula that looks for CTS in a pivot table Example: FMM CTS 500 and FSM CTS 200 but occasionally FMM CTS is 0 and FSM CTS is 200 since this is...
April 15th, 2008 05:12 PM
by uvknights Go to last post
0 92
#REF! trying to white out by cac1966
I have copied a formula on a ledger for Purchase Orders. As I place an order into a worksheet the information automatically fills on the ledger (separate...
March 29th, 2007 09:22 PM
by Max Go to last post
3 63
#REF!, TRUE or FALSE by Hurtige
Hi everybody Im working on a worksheet where i wanna check cells in two other types of work sheets but but only one of the exists for each number. Ive made...
August 11th, 2006 02:18 PM
by Bernie Deitrick Go to last post
1 130
#REF# Problem by [email protected][_2_]
I set up a spreadsheet that is run on formulas, which is reading from ACCESS query. Every time the query refreshes, if there is a change, all my formulas turn...
September 30th, 2007 02:38 AM
by [email protected][_2_] Go to last post
1 75
#VAlUE by Chi
Hi, the #VALUE error appeared when I deleted value of the cells. EX: My formula is A3= A1/A2. The formula works fine, but after I clear the value of A1 and...
April 1st, 2008 05:03 PM
by muddan madhu Go to last post
3 62
#VALUE by
I'm using the below formula and keep getting #VALUE as a result when D20 is 0 or D20 is blank--what I'm trying to achieve is if D20=0 OR D20 is blank, the...
July 26th, 2004 02:12 PM
by Go to last post
2 108
Post New Thread


Display Options
Showing threads 221 to 240 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:59 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.