You are here: HomeExcelTutorials

# #REF Error when summing

## #REF Error when summing

Price: FREE

I keep getting this error #REF When trying to Sum Cell A1 which contains
2001:2003!A1. I have tried Sum(A1),Sum(INDIRECT(A1)), Sum(Concatenate(A1)). None of which seem to work.

Visit publisher's web-site: #REF Error when summing

Category and Tags: ExcelTutorials :

## Related Tutorials

### #VALUE! when summing the products of two column

Free: Yes
Tags: Excel ›

How can I make my formula work when summing the products of two column on the attached table? I am trying to calculate the cost of my product (E78) by summing (C54:C76) with (E54:E76). It returns #VALUE! error.
I believe it is to do with some text in between the selected area.
Please help, I don't want to do it like D78 by adding them individually.

### Summing based on multiple criteria

Free: Yes
Tags: Excel ›

Can somebody please help me with this as its driving me nuts and I'm very close to launching my laptop out of the window.
In a nut shell this is what I am trying to achieve,
I want Excel to SUM coulomb H where,
the date in coulomb C is greater than (Ref to cell with date entered)
the date in coulomb C is less than (ref to cell with date entered)
Coulomb E = (Ref to cell with name in)
& Coulomb F = (Ref to Cell with name in)
Hope that all makes sense, very quick draft copy attached.

### How to avoid #REF!, #VALUE! error

Free: Yes
Tags: Excel ›

I have prepared an excel sheet initial all the formula was working fine but now suddenly it stopped working and I am getting #ref! error and # value! error.

### #REF! Error Resolve?

Free: Yes
Tags: Excel › Functions

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 replaced with a numerical outcome of 0 or 1.
Is there an addition to the formula below which I can use to just leave the cell "blank" until the data is input in A4 and B4. I just hate seeing that #REF! Error!
=IF(AND(SUMPRODUCT(--(rnga<>""),--(rngb<>""),--(rnga=\$A4),--(rngb=\$B4))>1,C4<>"x"),1,0)

### summing the number of dates

Free: Yes
Tags: Excel ›

The scenario:
cell A - I have a range of date (title Date) and cell B - I have a range of incidents (title Error Dept)
Date | Error Dept
Feb 12 D
Feb 13 D
Feb 12 D
How can I formula the results that tells me there are 2 Ds in Feb 12 from Error Department.

## Related Applications & Scripts

### Error Reporter

Free: No
Tags: PHP › Excel Error Handling

“Error Reporter” simply show or/and emails all of the php errors and exceptions in clean interface. You can easily set a perfect error reporter for your web site/app with only one include. You can set generic error page to show your users when any error occurs, and you can set error reports delivered by email.

### JS Error Log

Free: No

JS Error Log is a simple set of PHP classes and jQuery plugin which allows log and store all JS errors as PHP errors.
Features
- Write all JS errors to CSV files located on server,
- Can Log data:
- - date, time, error message, error URL , error line number, client IP, client host name, client user-agent, Send errors to mailbox, Documentation included.

### Lunch Break Error Page XML

Free: No
Tags: Flash › Excel Web Layouts

Complete, animated and sounded coming soon under construction HTML page template with XML custom external logo, music, adjustable multiline textblock with tags support and alternative URL link. Silhouette dancer working man from sign with interactive animation centered in browser window. Your logo is clickable with custom URL .

### EasyValidation - PHP Special validation class

Free: No

EasyValidation is a special PHP class to validate data, It helps you validate forms, Or variables in seconds. It uses two types of validation, The regex validations and, The PHP Validations (PHP Scripts that validates the data).
EasyValidation is easy to use & simple to modify. The thing so special about EasyValidation is that you can add your own validations in second, Whether it’s a regex validation or a PHP one.
Each validation also has its own “Validation error text”, The validation error text is the error that will be provided if the data was not valid.

### Animated Flash/PHP FormMailer

Free: No
Tags: Flash › Excel Forms PHP

- Vector Mail Animation (can be resized)
- Required Fields : Message is only sent if all fields are filled, otherwise an error text will be displayed for one second
- Email-Check : Checks if the email is correct
- Mail-Check : Notification if Message was sent successfully or if there was an error while sending
- works with PHP 4 & 5
- Secure : php file only sends Mail if flash vars are passed
- sends you the IP of the sender
- DragnDrop
can be dragged to any movieclip
- documented code (written in AS1 .0)