| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a #Ref! in a column Sum
I'm doing a spreadsheet for payroll. I have set up cells that will imput as
the spreadsheet for that pay period is created. Right now, those cells are #Ref!, which is fine because they're referencing a file we haven't created yet. The problem is that I need to total that column with the Ref cells, but the total ends up as a Ref error. Is there a way to tell it to make the Ref=0, and still sum the column? ex. Month Hours Worked January 10 February 40 March 40 April 10 May 40 June 40 July 10 August 40 September 40 October 10 November #Ref! December #Ref! Total #Ref! Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a #Ref! in a column Sum
Use ISERROR
=IF(ISERROR(your formula here),"",your formula here) "dzenifr" wrote: I'm doing a spreadsheet for payroll. I have set up cells that will imput as the spreadsheet for that pay period is created. Right now, those cells are #Ref!, which is fine because they're referencing a file we haven't created yet. The problem is that I need to total that column with the Ref cells, but the total ends up as a Ref error. Is there a way to tell it to make the Ref=0, and still sum the column? ex. Month Hours Worked January 10 February 40 March 40 April 10 May 40 June 40 July 10 August 40 September 40 October 10 November #Ref! December #Ref! Total #Ref! Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a #Ref! in a column Sum
Try
=SUMIF(B2:B13,"<"&99^99) -- Regards, Peo Sjoblom "dzenifr" wrote in message ... I'm doing a spreadsheet for payroll. I have set up cells that will imput as the spreadsheet for that pay period is created. Right now, those cells are #Ref!, which is fine because they're referencing a file we haven't created yet. The problem is that I need to total that column with the Ref cells, but the total ends up as a Ref error. Is there a way to tell it to make the Ref=0, and still sum the column? ex. Month Hours Worked January 10 February 40 March 40 April 10 May 40 June 40 July 10 August 40 September 40 October 10 November #Ref! December #Ref! Total #Ref! Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a #Ref! in a column Sum
I figured this out moments before I checked back and it does work for what
I'm doing. Thank you for such a quick response though! "Sheeloo" wrote: Use ISERROR =IF(ISERROR(your formula here),"",your formula here) "dzenifr" wrote: I'm doing a spreadsheet for payroll. I have set up cells that will imput as the spreadsheet for that pay period is created. Right now, those cells are #Ref!, which is fine because they're referencing a file we haven't created yet. The problem is that I need to total that column with the Ref cells, but the total ends up as a Ref error. Is there a way to tell it to make the Ref=0, and still sum the column? ex. Month Hours Worked January 10 February 40 March 40 April 10 May 40 June 40 July 10 August 40 September 40 October 10 November #Ref! December #Ref! Total #Ref! Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
Linear Mode
