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!

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!

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!

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!